There is always a lot of debate about how to design SSIS packages. The question always is whether to use components or TSQL in SSIS packages and which would perform better. Recently a discussion in the MSBI groups in Linkedin has started off a very good debate.
Here is the link:
SSIS - TSQL Stored Procedures Vs SSIS inbuilt transformations
http://www.linkedin.com/groupItem?view=&gid=59185&type=member&item=111443713&qid=bb7bcd72-ff00-493a-a853-3fdd61f3d9d9&trk=group_most_recent_rich-0-b-cmr&goback=%2Egmr_59185
There are some very good points for using SP/SQL and Components.
No comments:
Post a Comment