DTS Package Permission Issues - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

DTS Package Permission Issues

Author

Topic

satishvsh
Starting Member

41 Posts

Posted - 2008-07-28 : 12:55:28

Friends -

I am getting the following error. could some one please help me out to fix this issue.

Environment : Windows 2003
Database : SQL Server 2000/2005

Package Steps execution information: Step 'DTSStep_DTSActiveScriptTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Error Code: 0 Error Source= Microsoft VBScript runtime error Error Description: Permission denied: 'CreateObject'

Error on Line (xx)

Step Error code: 800403FE Step Error Help File:sqldts80.hlp Step Error Help Context ID:4500

Please advise

Cheers :)
Satish

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-28 : 23:00:48

How do you connect to sql in the package? Does the account used have proper permission?

jason7655
Starting Member

24 Posts

Posted - 2008-07-30 : 10:14:10

Check OS permissions as well if you are doing anything with the file system.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources