- Start in the package Control Flow, with no object
selected (Press ESC in the main window).
- Right click the background in the package, and select
- Add a variable called LoopIteration with the Int32
data type in the package.
- Add a For Loop Container to the package
- Edit the For Loop Container by double-clicking it, or
right-clicking it and choosing Edit.
- Set the InitExpression to @[User::LoopIteration]=0
- Set the EvalExpression to @[User::LoopIteration]<5
where 5 would is the number of loops you want to run.
- Set the AssignExpression to @[User::LoopIteration]=@[User::LoopIteration]+1
- Your settings should now look like this:
Converting SSIS Data Types to .Net Data TypesWednesday 14 February 2007
If you use Scripting tasks, the CLR or build components for SSIS, you will need to convert values from their SSIS types into .Net types. Here’s a quick list of the SSIS data types and their .Net companion. Integration Services Data Types Managed Data Type DT_WSTR DT_TEXT DT_STR System.String DT_BYTES DT_IMAGE System.Byte […]
Generating a new SSIS Package GUID with the dtutil UtitlityFriday 9 February 2007
If you make a copy of a .dtsx file, the Package ID property remains the same. This value is logged as the SourceID, and to ensure it is unique, you should generate a new value for any copies of a package. dtutil /FILE "Copy of sample.dtsx" /IDRegenerate Or the short hand version dtutil /FILE "Copy […]
Simon Sabin’s SSIS Raw File ReaderFriday 12 January 2007
Ever used a Raw File destination in SSIS ? They’re FAST! Writing rows from the pipeline to disk as quickly as possible. Raw Files are useful for increasing the throughput speed of a data flow task by using them in Extract / Transform procedures. The reason they are so efficient is they stored the data […]