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)
 SSIS package keeps failing

Author  Topic 

latingntlman
Yak Posting Veteran

96 Posts

Posted - 2009-02-02 : 10:53:18
I created a package in VS 2005. Then I scheduled it to run thru sql mgmt console, but it keeps failing with the error msg below, and I'm not sure how to fix this. Mind you this is on my local machine using AdventureWorks Db. I'm trying to get a head on SSIS.

Message
The job failed. Unable to determine if the owner (DOMAIN\jdoe) of job Integration Services Package has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\jdoe', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).

Thx,

John

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-02 : 12:02:09
what permissions does DOMAIN\jdoe have on the server?
Go to Top of Page
   

- Advertisement -