Welcome to EMC Consulting Blogs

Browse by Tags

• Dataflow Task
• Expressions
• Foreach Loop
• SQL Server Integration Services

• SSIS Nugget: Splitting order detail and order header information from one file into multiple tables

  "I have a file that is a list of orders. Each record in the file contains the order number and the item that has been ordered along with information about that item (e.g. Quantity ordered). I want to split the file into an OrderHeader and an OrderDetail Read More... Posted 22 May 2006 22:32 by jamie.thomson | 13 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Dataflow Task, Nugget Attachment(s): 20060518Split_OrderHeader_OrderDetail.zip

• SSIS Nugget: Setting expressions

  Whilst reading posts on the SSIS forum of late it has become evident that people are unaware of the power that expressions can provide within an SSIS package. This is understandable - alot of people are starting to use SSIS now but expressions aren't Read More... Posted 11 March 2006 09:24 by jamie.thomson | 30 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Expressions, Foreach Loop, Nugget