|
|
Browse by Tags
All Tags » SSIS » Scripting » SQL Server Inte... » Foreach Loop
-
Its possible that at some point when building SSIS packages that you will want to initialise a variable with some value at execution time and the most obvious way of doing this is to use a script task. That code would look something like the following: Public Sub Main()
Dim vars As Variables
...
-
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 ...
|
|
|