November 5, 2012 at 4:44 pm
I have three column values (startdate, completedate, recordcount) that i get in txt audit file. I need to use those values downstream in my ssis package. I want those values in the ssis variables. Is there a way i can map them directly to ssis variables and use them instead of loading them into a table.
many thanks.
November 5, 2012 at 4:56 pm
Ok Found out there is recordset destination-never used that one.Anything to add?
November 5, 2012 at 11:36 pm
Yes, there's only a destination, not a source.
You need to write a script component as a source to read from the object variable where the recordset is stored in.
Somehow using a table seems easier to me 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 6, 2012 at 7:15 am
You can use a ForEach Loop task to read from a recordset object and assign the column values from each row to a variable.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply