September 16, 2011 at 7:15 am
I have one ssis package that is taking values from .csv file and insert it into 'mydata' table
but 'mydata' table also having one 'CompanyID' that i have stored into variable so how can i insert that
'CompanyID' aslo while mapping or how??
September 16, 2011 at 7:40 am
We need a little more information to answer your question.
How is the variable populated?
How does the variable relate to the .csv file?
How is the .csv file getting imported? (what source & destination transformations are you using, also list your connection manager types)
If companyID is separate from the file and just needs to be updated to the rows in the table, the easiest and quickest way would be to map the variable to an Execute SQL Task in your Control Flow and run an UPDATE statement.
The painful way to do it would be to add the Execute SQL Transformation in the Data Flow and do it the RBAR way. Or, less painful, use a Derived Column Transformation to just add a column with the variable result in it.
Depending on your answers to the above question, though, my answers may change.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply