SSIS Logging SP Name Has Changed

In SSIS SQL 2005, the stored procedure to write SSIS logging informwation was sp_dts_addlogentry. In case this sp does not exist in the logging database, it was created automatically.

When I ported a BI solution from SQL 2005 to SQL 2008, I was wondering why the logging was not working any more. Tracing the database activities with SQL Server Profile, the reason was crystal clear: they changed the name of the logging sp to sp_ssis_addlogentry. And also, SSIS does not create it any more in case it does not exist.

Leave a Comment

Please note that every comment requires the admin's approval before it will be published.

Any comment containing spam like "... great topic. Feel free to visit my web page ..." will be deleted. So please do not waste your and our time by leaving such comments.

We respect your privacy. When you leave a comment, your IP address will not be recorded by WordPress.