I am tasked to migrate a huge VBA application to SSIS. The VBA application reads the data tables, does huge manipulations and writes data to files and other tables.
I am new to SSIS and I am very much confused with the efficient control flow and data flow design.
To tell you in short, the VBA app loops the result set until the end of result set is reached. In between the loop there are many operations to fetch data from other data tables, file write operations etc.
Now, in SSIS, I can loop they data rows using a script component, but how do I invoke a Execute SQL task in between the execution of script component.?
I can create a source connection and output the result to a text file (separately), but how to do this in between when script component is running.
I hope you understood my problem !!
Please guide.. I know this is a bit design issue but I am not getting the right pointer
View Complete Post