May 27, 2009 at 3:51 pm
Hi, I am a newbie to SSIS. I am trying to export the count of the number of rows in a table to a text file. I setup an Execute SQL Task and am able to save the count to a variable. However, I don't know how to save that value to a text file. Can someone give me some assistance? Thanks for your help.
May 27, 2009 at 4:00 pm
I would add a script task to print the value of the variable to the text file.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
May 27, 2009 at 10:06 pm
Or you could use OpenRowset to do it directly from T-SQL.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
May 28, 2009 at 9:41 am
The script task worked. Thanks for your help.:-)
May 28, 2009 at 9:45 am
Weste (5/28/2009)
The script task worked. Thanks for your help.:-)
You're welcome.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply