September 10, 2013 at 5:03 am
Hi all,
A package has been created and I have scheduled it, when it runs it errors. The description to the error is"Executed as user: GMFS\sql_service_account. The package execution failed. The step failed." which is not very helpful. I can run the dtx package successfully.
The Protection Level is set to ‘EncryptSensitivewithPassword’
I have compared this with other packages that have been scheduled before and i can't see any differences.
Has anybody got any ideas?
September 10, 2013 at 5:34 am
Did you enable logging in the SSIS package? If yes, is there something useful in there?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
September 11, 2013 at 2:55 am
Hi,
Yes I did enable logging in the SSIS package, but there anything useful to see.
September 11, 2013 at 3:08 am
clucasi (9/11/2013)
Hi,Yes I did enable logging in the SSIS package, but there anything useful to see.
Which events did you log?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply