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...

Will the indirect configurations be for the same values set in Configuration file?...

Hi Nirav, In step 4 where you are updating the invalid flag, use a multicast before that. Then do your update to Original table and the Oracle table using 2 OLED command. If you want to do away with OLEDB COmmand, you could do this update in execut...

Hi Nirav, Could you mention the steps and the transforms you are using....

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...

Lets assume that we have 2 files coming in a folder. One with the name 1.txt and other with the name 2.txt. Now the requirement says that we if the date is odd you process file 1, else process File 2. Set up a variable to save the file name using ...

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"...

Hi Nrvinay, Could you give me details of what you are trying to do?...

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?...