Only One SSIS Job Runs...

Hi,

Currently I have two SSIS jobs on my machine. The problem I'm having is, only one of the jobs executes succesfully, the other one fails for incorrect user login. Both jobs use the same configuration database and all the packages on both jobs have the protection level set to "DontSaveSensitive". Both jobs have been deployed in the exact same manner, yet only one succeceeds and the other fails.

Can anybody tell me why this is going on?

J.Suazo wrote:

Hi,

Currently I have two SSIS jobs on my machine. The problem I'm having is, only one of the jobs executes succesfully, the other one fails for incorrect user login. Both jobs use the same configuration database and all the packages on both jobs have the protection level set to "DontSaveSensitive". Both jobs have been deployed in the exact same manner, yet only one succeceeds and the other fails.

Can anybody tell me why this is going on?

I would suggest to double check....take close look wehre the error is happening. Are the 2 jobs calling the same package?

|||

Hi Rafael,

Thanks for your reply.

1. The packages fail when acquiring my sql server connection. The error I'm getting says that the connection is not configured correctly or I may not have the right permissions. That is bogus, the packages on my other job have the same connections and the same permissions and they don't fail.

2. Both jobs call completely different packages.