So I'm importing data from a fixed length flat file into a single table. In order to insert the data I need to generate a master record and then use the MasterRecordID in each row that I insert. I've created a sql task that calls the SPROC that creates the master and record and returns the MasterRecordID. I'm storing this in a package variable. So how the heck do I get this thing into the data stream that is getting written to the SQL table? The table already has a field for it I just don't see a way to put it in the destination component on my data flow component. Is there like a transformation that will do this or something? I'm new to SSIS. Any help would be appreciated. Thanks, Jon

Derived Column transformation. The value is the variable. Set it to add as new column.Russel Loski, MCITP Business Intelligence Developer and Database Developer 2008