March 4, 2008 at 5:13 am
Hello,
I want to log all my DTS (~400) to the sysdts.... tables in the msdb Database. How can I do that? Does exist a property that switched the logging on or off.
I know that a property exists inside of a DTS but I don´t want to open every DTS and that the logging property manually.
The System is running on a SQL-Server 2000
Thanks for helping me.
March 4, 2008 at 10:13 am
I think you'll need to use the DTS Object Model. Check out this article: http://www.sqlservercentral.com/articles/DTS/automatedtslogging/1124/
Greg
March 5, 2008 at 3:08 am
i have to use C# and not VB-Code.
It´s a company philosophy.
In C# I don´t get an DTS Object inside the SQLDMO.dll
Can you help me?
Thanks
March 5, 2008 at 9:13 am
Sorry, I can't help with C# code. I've only used VB to work with the DTS Object Model. BTW, it's DTSPkg.RLL rather than SQLDMO.RLL.
Greg
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply