April 25, 2011 at 8:14 am
Hi,
I am Executing stored procedure through Execute sql task. Through SSIS, I am inserting into some tables and I am getting the rowcounts of every insert through the output parameters into variables. Now I need that values to be passed to the text file so that rowcount can be known. Please help me out
April 25, 2011 at 9:26 am
April 26, 2011 at 7:43 am
An alternative to setting up a file connection and then dumping the variables is simply report the values in an email task to yourself (or, whoever needs to check the values) by setting the message body to a variable (MessageSourceType = Variable, MessageSource = ), and set that body variable as an expression to detail out what you need to see.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply