Andy has more SSIS goodness.
This script uses an OLEDbDataAdapter (oleDA) to fill a DataTable (dt) with the contents of the dsVar SSIS package variable, then iterates each row and column to build a string containing the data in the row. It then pops up a messagebox for each row displaying the row's contents before moving to the next row.
Andy Leonard : SSIS Design Pattern - Read a DataSet From Variable In a Script Task
No comments:
Post a Comment