blogs.conchango.com

Browse by Tags

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

• SSIS: Processing data from multiple files all at once

  Quite often you may want to process data from multiple files all at the same time. There are a number of options available to you if you want to do this. 1. Have a seperate source adapter for each file and amalgamate them together with the Union All component. Read More... Posted 14 October 2006 17:54 by jamie.thomson | 2 Comments Filed under: SQL Server Integration Services, SSIS, raw files, Dataflow Task, Foreach Loop

• SSIS: Getting a value out of a file to use it in our package

  Someone recently asked on a newsgroup how they could grab hold of a value from a given field in the last row of a file. For example, in the file depicted below we would like to grab the value "Posh". I figured this might be a fairly common requirement Read More... Posted 15 June 2005 22:21 by jamie.thomson | 4 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Foreach Loop

• SSIS: Accessing a recordset in a script task

  UPDATE 2006-03-14: This information in this post should now be disregarded. Read here: http://blogs.conchango.com/jamiethomson/archive/2006/01/04/2540.aspx instead! It is possible to populate an SSIS variable of type "Object" with a recordset using the Read More... Posted 08 February 2005 23:13 by jamie.thomson | 13 Comments Filed under: SQL Server Integration Services, SSIS, Dataflow Task, Scripting, Foreach Loop