blogs.conchango.com

Browse by Tags

• raw files
• SQL
• SQL Server
• SQL Server Integration Services
• SSIS

• SSIS: Data flows or T-SQL

  Update below There has been, and still is, quite alot of conjecture in Conchango as to whether one should use SSIS data-flows or stored procedures for ETL. Traditionally we have implemented ETL solutions using stored procedures. DTS was used but as little Read More... Posted 14 March 2006 23:26 by jamie.thomson | 44 Comments Filed under: SQL Server Integration Services, SSIS, raw files, T-SQL, Dataflow Task

• SSIS: How to load related tables

  It is a very common scenario to be able to load two tables in the same data-flow that have a foreign key relationship between them. The question of how to do this gets raised very often on the SSIS forum so I figured I'd try and address it here. Basically, Read More... Posted 17 February 2006 18:02 by jamie.thomson | 16 Comments Filed under: SQL Server Integration Services, SQL Server, SQL, SSIS, raw files, T-SQL, Dataflow Task