.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSIS installation

Posted By:      Posted Date: September 08, 2010    Points: 0   Category :ASP.Net
 Hi all, Sql server 2005 is already installes in my machine.., i want to use SSIS now. can anyone help me from where can i download SSIS package as add on to sql server 2005.   Thanks in advance Suresh G  

View Complete Post

More Related Resource Links

ssis deployment issue - Unable to load custom dll - due to change in Sql server installation


Hello all

I had a strange issue in testing my package, after it was deployed to a Test server.

The details of the server

Sql 2005 is installed, in the D:\ drive

I have used a package, where i use a custom DLL to read values. Hence, i added that DLL to the GAC. I was in the assumption that this should complete my proceess of deploying this package.


However once i executed the package, i got an error - Could not load the Helper object.

Unable to CAST "system.object"  to namaspace.class.Helper.


I reviewed the setting on my macihine, since as part of development inorder to reference the dll i added this to the C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies location so that i can reference this from BIDS. I checked that location in my test server, i was not present. This location was present in the D: drive ( i assume this was present since i installed my complete SQL Server in the D:\ ). I copied the dLL in that location and added it to GAC from that location. My package still failed with the same error.


To resolve this issue, i created the same path in the C:\ folder as C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

assemblies was newly created in C: and i added the dll to GAC from there. Now my package worked.


Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

Installation problem with VWD 2010 on XP sp3.



I have installed Xp sp3 in my system.When ever i install VWD 2010. I will get auto shutdown of System. But it support vs 2005, VWD 2008 Sp1 with sql 2005 very well without any problem. Again whenever i try to Sql server 2008 express. I will get auto shutdown problem.

But i have read on Microsoft site, VWD 2010 and sql 2008 support XP sp3.  My system does not support good graphic and sound in Window 7 OS. I have MSI mother board and AMD dual core processor with 2 GB Ram.

what is the problem ? is there problem with hardware ?

Toolbox: WiX Installation, Creating PowerPoint Decks, and More


The WiX toolset's use of a command-line environment allows for integration with automated build processes. The Toolbox column explains.

Scott Mitchell

MSDN Magazine April 2007

Bootstrapper: Use the Visual Studio 2005 Bootstrapper to Kick-Start Your Installation


There are plenty of times when you need to get information on running processes, not the least of which is during performance tuning. Using the techniques in this article and special .NET classes you'll see how to get a process' ID, name, priority, number of threads, kernel handle, and memory consumption, as well as its user-mode, kernel-mode, and total elapsed running time and put them to use in a custom app called AssemblyBrowser.

Sean Draine

MSDN Magazine October 2004

Problem in Installation of SQL Server 2008


Dear All,

I have Sqlserver2008 setup.

It is work in wndows Xp.

But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.

Plz some buddy can help the same.


Rakesh gupta

MOSS 07 Installation Quirks - SSRS Connectivity & SSP Permissions

I'm new to MOSS 07 and am currently learning it.  I've done clean installs and post-install configuration a few times now and I've noticed 2 quirks associated with a fresh install.  I'm not sure what is going on or the best way to "fix" them.

1 - I install SQL 05 with SSRS prior to installing MOSS and I always check to make sure that SSRS is configured and I can connect to it in the SQL Management Studio.  Once the Default port 80 Web App is provisioned, however, I can no longer connect to SSRS via the SQL MS.  I understand that this is related to the fact that the default Web App that hosts the SSRS sites is the Default 80 Web Site and that this port is taken over by the SharePoint 80 portal.  My question is, how to handle this.  I understand that I can configure SSRS to run via SP Integration.  However, when I install SSRS 05 initially and prior to installing/configuring MOSS, should SSRS be installed under a separate Web App and Port than the Default?  Does SP Integration restore the ability to connect to SSRS via the SQL Mang. Studio?

2 - In an attempt to get used to a "production" way of doing things, I create Domain Service accounts for both installing MOSS and running the services.  My problem is with the results of using an installation account.  I call it "spinsta

using SharePoint List for SSIS package

I need to use a sharepoint list as data source for SSIS package, it works fine until the sharepoint site implement Kerberos only (IIS 7) authentication, anyone knows how to get around this? thanks.

SharePoint 2007 SP2 Installation



I want to update SharePoint by installing MOSS SP2 but i am unable to find any link related to this. I have read several articles regarding the "Expiration date issue" and not getting which update to download.

Can anyone please give me the link from where i can download latest MOSS SP2 without that date issue?



Migrate DB + files outside DB into SharePoint using SSIS and scripts


Hello, just wanted to ask a question about SSIS and SharePoint, any input will be greatly appreciated.... did search the forum but could not find anything....

So basically we have a SQL Server DB with the metadata ONLY, WITHOUT the related files(doc/ppt/pdf..etc) which should've been in the DB and they are on a separate web server inside folders. Each row in the DB has a key (column) which matches the related folder's name, so for row with ID #112, there's a folder named ID112 on the web server with the relevant files inside. There could be more than 8+ files for one folder.  

Now, I think it is possible but just wanted to double check, would it be possible to use SSIS and some kind of a script to get the metadata inside the SQL DB AND the related files inside those folders, combine & relate them and upload them into SharePoint as a custom list with file attachments? would they display the attachment normally (like the paperclip icon in a sharepoint list...etc) I wonder if anyone has tried this...

Any guidance, thoughts, suggestions for other solutions, inputs will be great!!! Thank you!!



Issues with SharePoint 2010 Installation


Hi All,

I have got error while installing sharePoint 2010 as follows and answer also present below,but i could not able to find the patch as mentioned in the solution below I.e: "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\UpdateExeVolatile"

I my machine is not the base machine its a VM running with Windows Server 2008 standard and SQL Server 2008 R2......

ANy help much appreciated...

ISSUE #3:  when running Setup.exe for Microsoft SharePoint Server 2010 you may experience the error:

Setup is unable to proceed due to the following error(s):
A system restart from a previous installation or update is pending. Restart your computer and run setup to continue.
For the list of pre-requisites needed to install the product please refer to:
Correct the issue(s) listed above and re-run setup.

Check the value of the following Registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\UpdateExeVolatile - if the value of the UpdateExeVolatile Registry key is anything other than 0 you will see this message.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Pendi

Problem in Installation, Please help


Hi all I have installed wss3.0 with sp2 on windows 7, every thing went fine but when i open central administration "Create New Web Application" link is not visible and when i go to create new site collection "OK" button is disabled.

i have checked my user(local admin) is available in the farm administrator group.


Can anyone help please? I have same problem on Windows 7 32 and 64 bit versions.


VS 2008 Install - Windows Mobile 5.0 SDK R2 for Pocket PC: [2] Error: Installation failed for compon



I am trying to install VS2008 on my Windows XP machine. I have MS Office 2003 and SP2. Disabled the Norton Anti-Virus. I am getting the following error. I appreciate if some one can help me.

[08/26/10,07:04:36] Windows Mobile 5.0 SDK R2 for Pocket PC: [2] Error: Installation failed for component Windows Mobile 5.0 SDK R2 for Pocket PC. MSI returned error code 30
[08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Windows Mobile 5.0 SDK R2 for Pocket PC is not installed.
[08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Windows Mobile 5.0 SDK R2 for Smartphone was not attempted to be installed.
[08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft Device Emulator version 3.0 was not attempted to be installed.
[08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft SQL Server 2005 Express Edition (x86) was not attempted to be installed.
[08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Crystal Reports Basic for Visual Studio 2008 was not attempted to be installed.
[08/26/10,07:04:39] VS70pgui: [2] DepCheck indicates Microsoft Windows SDK for Visual Studio 2008 Tools (x86) was not attempted to be installed.
[08/26/10,07:04:40] VS70pgui: [2] DepCheck indicates Microsoft Windows SDK for Visual Studio 2008 Headers and Libraries (x86) was not attempted to be installed.
[08/26/10,07:04:40] VS70pgui: [2] DepCheck indicates Microsoft

Microsoft .net framework 1.1 installation problem

Well I know there is numerous posts about .net framework 1.1 installation failure,I have searched through a lot of them.I failed to resolve my  problem so I am posting this.when I try to install .net framework 1.1 redistributable package which I downloaded from here it installs  .net framework version 1.0.3705 then when I want to install .net framework 1.1 service pack 1 downloaded from here which has the file NDP1.1sp1-KB867460-X86.exe  it doesnt install showing the message  ''The upgrade patch can't be installed by the windows installer service because the program to be upgraded may be missing,or the upgrade patch may update a different version of the program.Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch.'' I have tried a lot of way to solve this including:using the stebner cleanup tool to erase all versions of framework then restarting  machine and reinstalling again but this way can't solve the problem,modifying registry etc.Other versions(1.0,2.0,3.0,3.5) are installing smoothly they are not creating problems only this fw 1.1.How can I resolve this issue.Please anyone help

.NET 3.5 SP1 installation failed

I'm trying to install U2U CAML Query Builder in XP Pro SP3 and I have .NET 2 SP2 installed. Here's my install log: The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.1.3 {version} Running checks for package 'Windows Installer 3.1', phase BuildList The following properties have been set for package 'Windows Installer 3.1': Running checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true Result of checks for command 'WindowsInstaller3_1\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' 'Windows Installer 3.1' RunCheck result: No Install Needed Running checks for package '.NET Framework 3.5 SP1', phase BuildList Reading value 'SP' of registry key 'HKLM\Software\Microsoft\NET Framework Setup\NDP\v3.5' Unable to read registry value Not setting value for property 'DotNet35SP' The following properties have been set for package '.NET Framework 3.5 SP1': Running checks for command 'DotNetFX35SP1\dotNetFx35setup.exe' Skipping ByPassIf because Property 'DotNet35SP' was not defined Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of running operator 'VersionLessThan' on pro

Microsoft .NET Framework 2.0SP1 (CBS): [2] Error: Installation failed for component Microsoft .NET F

I downloaded the the .Net Framework 3.5 from Microsoft and I am trying to install the .Net Framework 3.5 in a clean Windows Vista Ultimate installation but it fails. The dd_dotnetfx35error file shows:   [03/08/08,19:05:35] Microsoft .NET Framework 2.0SP1 (CBS): [2] Error: Installation failed for component Microsoft .NET Framework 2.0SP1 (CBS). MSI returned error code 1[03/08/08,19:05:46] WapUI: [2] DepCheck indicates Microsoft .NET Framework 2.0SP1 (CBS) is not installed. Thank you for your help.

Find and replacement SSIS Custom component issues

Hi All, I developed one custom component in SSIS  Find and Replacement I register the dll and copy and paste in to Pipleline component. but it's not visible in the Toolbox while choose Items Please suggest why it's not comming.. using   System; using   System.Collections.Generic; using   System.Linq; using   System.Text; using   Microsoft.SqlServer.Dts.Pipeline; using   Microsoft.SqlServer.Dts.Design; using   Microsoft.SqlServer.Dts.Runtime.Wrapper; using   Microsoft.SqlServer.Dts.Pipeline.Wrapper; using   System.Data.OleDb; using   System.Data.SqlClient; using   System.Windows.Forms; using   System.Runtime.InteropServices; using   System.Data; using   System.Collections; using   Microsoft.SqlServer.Dts.Runtime; using   Microsoft.SqlServer.Server; namespace   FindAndReplace { [ ComVisible(true)] [ DtsPipelineComponent ( DisplayName = "Find and Replace", Description = "Finding Find and replace", IconResource = "Microsoft.Samples.SqlServer.Dts.Find and Replace.ico", ComponentType = ComponentType.Transform )]   class FindAndReplace :PipelineComponent {   #region   ProvideComponentProperties   /// <summary>   /// </summary>   public ove
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend