LutzM (12/16/2013)
Based on your descriptionI need to iterate a result set, do some simple processing on it and then write that processed data to a file or even a database.
I'm wondering if it wouldn't be easier to load the data directly into the database and call a stored procedure to do "some simple processing".
It depends on what that "simple processing" actually is...
Actually, I have to extract data, change it in C# script and then prepare batch INSERT statements in the C# code. After that, I have to execute these insert statements on a target database.
For now, I am assuming that I have to use only SSIS and not SQL server side code to do the job.