March 4, 2010 at 12:42 pm
I have a foreach loop I am running, and I'd like to write something to a file as it passes each loop.
I think I'm supposed to use a script task, but I'm not sure. I'd like to write a variable and success or failure to a text file and then email it to myself. Or save it in a db and then somehow notify myself.
Can someone shoot me a link or a snippet to get started?
thanks very much!
March 5, 2010 at 5:14 pm
Yes, you can do this, please refer to the following links:
http://qa.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/
http://msdn.microsoft.com/en-us/library/ms141724.aspx
I hope this helps...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 2, 2011 at 11:24 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply