You will need to create the select query as a string(dynamic SQL) and then execute it. This could be configured by passing the column names as parameters to sp or store the column names in table, or if it's all the columns of a table you could use syste...

Yes it is possible if the number of Square files is same as the number of circle files and the number after each square file is same in the circle file. For example if you have 2 square files with names Square1.txt, square2.txt, you should have 2 circle...

Hi Kpann, You need to set up the destination connection manager dynamically as well the way you set up the source connection. your expression would be something like: "C:\YourFolderPath\" + @[User::FileName] + ".xlsx"...

Ok makes sense. However it would be nice if you add that this helped you, and this is not a blanket approach that can be taken for all the cases with the same error....

How is your XML structure? Is it a simple one like I used?...

Hi Paresh, Did you have Excel connections in your Packages? You will see this error for Excel connections generally. Another reason for this happening could be that the User running the job does not have the necessary privileges....

I would prefer to use SSIS Raw file to stage the data from prod, and then use these Raw files to restore the data to the other server. Using raw file is the fasted way to have a backup of the data in case of any failure we donot want to hit the prod...

Store the value in a variable and map it in REadOnlyVariable in Script Task pop up. In the actual script you need to use it like: //Override the AcquireConnections Method to set up the connection once for the file. public override void AcquireCo...

You could mail it to me sudeep@beyondrelational.com...

Could you share your XML sample here....