We help IT Professionals succeed at work.

Integrated Services: Customising sysdtslog90

Medium Priority
709 Views
Last Modified: 2013-11-10
Hi there

I am putting the SSIS log into SQL Server.  I would like to customise the sysdtslog90 by putting an extra data that come from the VARIABLE within the package.

So my question is this possible? How do I do that?

Thanks
Comment
Watch Question

Commented:
Yes... update the stored procedure sp_dts_addlogentry that is generated by SSIS.
Follow the images to understand the environment.
Helped?
regards,
Pedro
www.pedrocgd.blogspot.com
SSIS-LoggingProvider1.JPG
SSIS-LoggingProvider2.JPG
SSIS-LoggingProvider3.JPG
SSIS-LoggingProvider4.JPG
SSIS-LoggingProvider5.JPG

Author

Commented:
I've been using and configuring this logging. But let say I've modified the sysdstslog table as well as the stored procedure. I assume that something that I would like to have an extra logswithin in my package, I have to run this stored procedure using script task ... correct?

Thanks

Author

Commented:
Also, can I rename this table and this stored procedure but then how the PACKAGE know which DTSLog stored procedure needs to be run? Where that definition sits?

Thanks

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.