SSIS Logging to both Text and Table at the same time
Using the log provider we can do logging to one of the log providers, but, I have a situation where I need to do logging to both text file and the sql server table. Any ideas on how to accomplish this, or is there already a feature which I have overlooked.
February 11th, 2011 5:35am
What if you setup an SSIS job to copy over from table to text file every 15 minutes?Kalman Toth, Business Intelligence Developer; SQL 2008 GRAND SLAM
Free Windows Admin Tool Kit Click here and download it now
February 11th, 2011 5:46am
You can use multiple providers for logging. Just add the providers for SQL Server and Text Files and enable them both using the Configure SSIS Logs dialog box.every day is a school day
My Blog
February 11th, 2011 5:54am
This topic is archived. No further replies will be accepted.
Other recent topics
