February 2, 2009 at 8:51 am
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 (LEFDOMAIN\jespinosa) of job Integration Services Package has server access (reason: Could not obtain information about Windows NT group/user 'LEFDOMAIN\jespinosa', error code 0x5. [SQLSTATE 42000] (Error 15404) The statement has been terminated. [SQLSTATE 01000] (Error 3621)).
Thx,
John
February 2, 2009 at 9:05 am
Is that a local account or a domain account? The error is saying it can't connect to the domain server to get credentials for the owner of the job. Either that or the account isn't one that's set up in SQL Server security.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 2, 2009 at 9:31 am
Give this user LEFDOMAIN\jespinosa access to db_dtsoperator in msdb database. Are you using proxy to run the job?
February 2, 2009 at 10:27 am
Thanks, that worked.
Another question:
I'm trying to add a Data Flow step to my package thru BI Studio, but can't seem to find the equivalent of sql 2000 Server Enterprise Manager "Execute Package Task". Whenever I needed to "drop a table step" as part of my DTS package, I would use this icon to write the sql command as part of the whole package.
Thx,
John
February 2, 2009 at 10:43 am
latingntlman (2/2/2009)
Thanks, that worked.Another question:
I'm trying to add a Data Flow step to my package thru BI Studio, but can't seem to find the equivalent of sql 2000 Server Enterprise Manager "Execute Package Task". Whenever I needed to "drop a table step" as part of my DTS package, I would use this icon to write the sql command as part of the whole package.
Thx,
John
Without looking it up I believe the Execute Package Task is avalable in the Control Flow, not the Data Flow.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply