Thursday, May 3, 2012

SSIS (Components Vs TSQL)

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
There are some very good points for using SP/SQL and Components.

No comments:

Post a Comment