Package Ownership Issue - 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

SSIS and Import/Export (2005)

Package Ownership Issue

Author

Topic

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-08-08 : 12:38:44

Ok...I dont know how to resolve this issue...

Package created by me, imported to sql server by dba, its executed under a different user id (all are NT logins)

Execution Command


DTEXEC /SQL "\pkg1" /SERVER SERVER1  /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E

Below is the error.


Code SnippetMicrosoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.

Started: 9:01:51 AM
Could not load package "\pkg1" because of error 0xC0014062.

Description: The LoadFromSQLServer method has encountered OLE DB error code 0x80040E14 (Only the owner of DTS Package 'pkg1' or a member of the sysadmin role may create new versions of it.). The SQL statement that was issued has failed.

Source: 
Started: 9:01:51 AM
Finished: 9:01:51 AM
Elapsed: 0.156 seconds

Any pointers???

Thanks
Karunakaran

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-08-08 : 14:08:27

Run as sql job? Possible to set proxy account for it?

karuna
Aged Yak Warrior

582 Posts

Posted - 2007-08-08 : 19:40:22

quote:
Originally posted by rmiao

Run as sql job? Possible to set proxy account for it?

We did that already it runs from Sql Server Job. But client does not want to use SQL Server Scheduler / Jobs. They have a 3rd party software for schedule maintanence.

Anyways, we fixed this issue by providing the db_dtsoperator role to the executing user.

Thanks
Karunakaran

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources