There is a dataflow task,which consists of excel source and sql destination.When executing dataflow task alone it is runing good.If i execute this dataflow taks inside a a for each loop ,it gives b...

I want to use an Execute SQL Task query to return varbinary data from a database table. The query requires a UniqueIdentifier as a parameter which is stored as string in a Package variable. The res...

I have two data sources, one sql table, one flat file (csv). Both sources have exact same columns. Example Data: Table: HCN Name Surname DOB 111 John Black 2013-12-10 222 Jack White 1989-01-14 33...

I am new to SSIS. I created SSIS Package using Execute SQL Task. I called a Stored Procedure. My stored procedure prints few messages like 'Insert Started' 'Update Started' 'Update Completed' but...

I want to export databases from our SQL Server 2008 to our PostgreSQL server. The problem is that during the Import/Export Wizard the Wizard says that he cannot find the correct file to convert pro...

I am trying to export data from a SQL server database into an excel file using SSIS. I want the data to get inserted from the 6th row and 5th row has headers. I am able map the header names, in ...

I have a ssis project in which the master package contains many child packages. All the child package are invoked with execute package task. I need to pass the "begin date" value from master to all...

What exactly is the use of Miscellaneous folder in the SSIS Solution folder hierarchy? I have use many packages and solutions as a part of the project,but never used this folder.I do understand tha...

I have only a single row that is being returned from a sql query(count(*)), but upon execution of the package, it shows me the above error and package is failing. I have the result type to "singl...

I have an SSIS 2008 package. I have 3 user variables in the package. One is for an the environment, one is for the path for an executable, and the other is part of a message for an email. I have ...