Shawn Weisfeld

I find when I talk to myself nobody listens. - Shawn Weisfeld
posts - 365, comments - 174, trackbacks - 34

My Links

News


Shawn Weisfeld's Facebook profile

The views expressed in this blog are mine and mine alone, not that of my employer, Microsoft, or anyone else’s. No warrantee is given for the quality of any material on this site.

Archives

Post Categories

SSIS

SSIS
Upgrade from SSIS 2005 to 2008 broke SSIS Logging

My DBA upgraded our server from 2005 to 2008 and when it did my SSIS packages stopped logging messages. Problem 1: Well the default logging mechanism in 2005 logs to the dbo.sysdtslog90 table. Well in 2008 they changed the table name to dbo.sysssislog. Not a big deal, but you will never find something if you look in the wrong place. Problem 2: Well now that I am looking at the right table, I noticed that my events were NOT showing up. In particular I was looking for the OnPreExecute and OnPostExecute methods. Poof gone, after many searches I stumbled across the following posts: https://connect.microsoft.com/SQLServer/feedback/details/491508/logging-of-ssis-tasks-are-incomplete-when-run-by-sql-agent-job?wa=wsignin1.0 http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/511502a6-99d6-4693-94da-2c317c3f59c6 Ahh,...

posted @ Wednesday, February 3, 2010 8:02 AM | Feedback (7) | Filed Under [ SSIS ]

Powered by: