February 17, 2010 at 10:14 am
Greetings all,
I am migrating from a SQL Server 2005 Server to a SQL Server 2008 Server. I have most everything migrated over now however the ETL SSIS packages are not showing up in the logs. For instance if I run the SSIS packages 'Load_SalesOrder' if I look at the windows nt log under applications it will tell me when it started and when it ended. On the new Server this is not occurring.
Is there something special I should be doing in order to get these packages to register in the logs?
Link to my blog http://notyelf.com/
February 17, 2010 at 10:36 am
Please check out the following Link:
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/
February 17, 2010 at 10:39 am
I found another Article that addresses Logging of SSIS Packages:
http://www.sql-server-performance.com/articles/biz/SSIS_Features_And_Properties_Part1_p1.aspx
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/
February 18, 2010 at 11:02 am
Thank you! These articles did the trick. That is strange that in 2005 they were logging right out of the box yet in 2008 you have to set it for each package.
Link to my blog http://notyelf.com/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply