Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL vs. SSIS - SCD Expand / Collapse
Author
Message
Posted Monday, June 20, 2011 3:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 7:06 AM
Points: 29, Visits: 117
Excellent article. Has anyone done any comparisons between SQL MERGE and the equivalent using SSIS (not using the standard SSIS SCD transform) ? and what were the results ?

Any further tips in deciding whether to go the SQL MERGE route or SSIS route ?

My take on it is as follows: SSIS is good for orchestrating workflow, and its data pipeline (eg inserting records in a table) and not good at batch processes such as updating tables. The standard SSIS SCD transform is a pain to work iteratively with - avoid.. My heart says build a USP with SQL MERGE, and execute the USP from a SQL task in SSIS. You can edit, update & tweak the USP to your heart's content and not necessarily affect the SSIS package.

Obviously the above is very simplistic, what do others think ?
Regards Geoff
Post #1128034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse