August 5, 2009 at 1:04 pm
I have a ssis package that loads data from flat file to loading table. After loading, the data gets flatten and inserted into some other tables into different database. I have three procs that handles this logic.
My question is WHich is better performance wise? calling these procs in ssis through execute sql task so now all i have is one ssis package in job step.
Or call each procs in job step after eecuting ssis package.
any thought will be helpful.
thanks
August 5, 2009 at 1:44 pm
Since you are using stored procedues and the DB engine is going to be doing all of the work, the only real benefit I see to calling the SPs outside of the SSIS package would be if your SSIS package is running on a remote server and you would save the round trip over the network. Other than that, I'd be surprised if both methods weren't really close in execution times.
This one does not sound like it would be difficult to try and find out! If you do mock up an test and run the comparison, please post your result here so we know.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply