Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Execute DTS Package using Window Logon Account

Author  Topic 

william_lee78
Yak Posting Veteran

53 Posts

Posted - 2005-11-09 : 05:19:23
Hi All,

I encountered a problem on executing a DTS Package using window logon account either through schedule job or through DTS Designer. Whenever I run the DTS package using window logon account, the DTS package will fail with the following error message:

Permission denied: 'CreateObject.ADOX.Catalog'

Can someone help me on resolving this issue? I need to use the window logon account to execute the DTS Package. Meanwhile, can someone tell me what are required permission to run the DTS package.

Thank you in advance for the help.

Regards,
William
   

- Advertisement -