June 25, 2010 at 1:53 pm
Hi folks,
I have developed SSIS packages where i call stored procedures from the control/data flow tasks. The question I have is, is there any best practices to choose Data Flow task over store procedures. Which is better to use Data flow task components or stored procedures, I have noticed that it is better to use MERGE/SORT in the stored procedure that use the SORT/MERGE component in SSIS Data Flow task.
Any thoughts/Suggestions on this issue.
Thank you
Ram
June 25, 2010 at 2:57 pm
I don't think this is a yes or a no answer. There are times when I can achieve something very effectivly though a stored procedure and there are also times when doing something in SSIS is more difficult to design but so much more efficient that it is worth the extra work.
you could also get into the argument of version control. If you have version control requirments the keeping everything in one SSIS is desireable for the purpose of maintaining those requirments.
There is a very long list of deabtable points in this topic and I am sure you would get a variety of answers but I still would argue that it is not always yes and not always no but depends greatly on your situations.
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
June 25, 2010 at 2:59 pm
Thank you Dan for the reply.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply