August 26, 2008 at 3:29 am
Hi,
I have a SSIS-package that runs fine when I manually start it from the SSIS tree in the development studio.
Then I created a SQL Server Agent Job - it wouldn't run 🙁
What I did:
- Create a Login Information (mine is in German so I'll try to find the right terms in English)
The user I used has "all" credentials
- Create a SSIS-Proxy an checked all subsystems
- Created a SQL-Server-Agent-Task
- owner = sa
- with 1 step
- Type = SSIS
- Run As = my SSIS-Proxy
- on the Data Source Tab: selected my Connections
- I don't have a configuration file - don't need any since I
developed the package on just this machine
- didn't make any other changes - don't know which wold be necessary
When I try to run that job I get the error:
(something like) Error while executing the package, error with step.
Something seems to be wrong with my step, but what???
Can anybody help me please?
Thanks!
Kai
August 26, 2008 at 4:32 am
Maybe I solved the problem myself:
When I edited the Step -> Datasource , I just checked the datasources, that I needed without editing the connection string.
Now I deleted the user_id and put in "Integrated Security='SSPI'" and it works :):):)
Thanks for your attention...
K.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply