|
|
Browse by Tags
All Tags » SSIS » SQL Server Inte... » Dataflow Task » Foreach Loop
-
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.
Advantages of this approach: This works well if the files are of ...
-
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 so figured I'd put something together to show how to do this. There's probably a number ...
-
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 ''Recordset Destination'' data flow destination component. Thereafter there are various ways ...
|
|
|