Category Archives: ETL

When to use T-SQL or SSIS for ETL

When doing ETL, you have the choice of using T-SQL or SSIS.  What things should you consider when deciding which one to use?  Here are some of the major design considerations to think about.  These points were derived from Tim … Continue reading

Posted in ETL, SQLServerPedia Syndication, SSIS | 14 Comments