We have few SSIS Packages . I want to enable logging for these. I have created OLED connection for SQL Server where I want to login . Enabled logging. Evrything is working fine and it is logging in to default sysdtslog90 table in msdb.I want to change this to someother database . I dont want the msdb to grow. How can I do this ?

When u choose logging option,Select SQL Server logging.While adding the connection, create a new connection to another DB.SSIS will automatically create the sysdtslog90 tbale and log there.Hope this helps !! Please close the thread once answered Sudeep My Blog

Nope it is not working.... I can see sp_dts_addlogentry stored procedure in msdb system stored procedures. Do I need to alter this ?

are you getting any error?I have never changed the SP u mentioned and can log to any other DB the way I stated.Hope this helps !! Please close the thread once answered Sudeep My Blog

Archies,What is the error?As sudeep has mentioned, sysdtslog90 table will be created inside the database.Have you checked in the database if any such table exits or not?Nitesh Rai- Please mark the post as answered if it answers your question

Its working now. I have messed up few things and was not looking in correct databse.

See this Article about implementing ssis logging various ways. http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document SSIS | SSIS Tasks | Real-time SSIS Monitoring