I created this ssis package on my pc. It runs great. But not when scheduled as a job.
I've searched all over the internet none of the fixes work.
Tried changing to savesentivewith password
tried changing runtime64bit to false
tried changing owner
NOTHING works. I am so frustrated
I have alot of servers this is the only one causing problems.
Date 9/28/2012 4:38:05 PM Log Job History (test)
Step ID 1 Server EQUINOX Job Name test Step Name test Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed
asked Sep 28 '12 at 09:03 PM in Default
answered Sep 29 '12 at 01:09 PM
FYI Had to create a new Credential to use for the ssis and then it worked.
answered Dec 19 '12 at 04:17 PM
I got the same issue before 1 year ago at that I was follow the above steps (Hondong metioned)
answered Dec 26 '12 at 04:42 PM