April 12, 2010 at 6:39 am
I hope someone can help with this, because I just CANNOT make it work. 🙁
I am trying to set a variable as a value collected from a database table, which is "Batch_Number" logging how many times that SSIS package has written data to the database.
I want the SSIS Package to add 1 to this and will then use derived columns to add this to record insertions.
I have added "Batch" to the variable collection as an integer.
I have collected the current Batch number via a OLEDB Datasource component. But try as I might I can't make the Execute SQL Task nor Script task set the variable to equal the collected value, which is now in the dataflow.
This is driving me nuts. Surely a simple task?
April 12, 2010 at 6:52 am
Done it. Sorry.. please ignore the question.
What I had failed to do was to set the ResultSet property to "Single Row".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply