All of the steps in the second job failed with the same error.

All three packages protection level property is set to EncryptSensitiveWithUserKey.

Lynn Pettis (3/26/2012)

---

Welsh Corgi (3/26/2012)

---

Did you ever find a solution to this problem?

I have a job that executes 4 pages.

The last one fails with an invalid password.

I execute the Package...

Lynn Pettis (3/26/2012)

---

Welsh Corgi (3/26/2012)

---

Did you ever find a solution to this problem?

I have a job that executes 4 pages.

The last one fails with an invalid password.

I execute the Package...

Did you ever find a solution to this problem?

I have a job that executes 4 pages.

The last one fails with an invalid password.

I execute the Package from BIDS on the...

I did not see a check box (Save password).

I checked alllow saving password, redeployed and the job failed.

That's odd, I wonder why it saved the PW for the other 3 packages in the job.

I will...

Just got out...

I did not save sensitive Data.

There are 4 packages in the Job.

I deleted the deployment folder, tested the connection with the password, etc. Job still fails.

I'm running it from BIDS...

I just noticed that you can't go into design view if you store the SSIS Package in MSDB?

Yes, of course BOL.:blush:

Thanks for the link to the video.

opc.three (3/26/2012)

---

PS This allows me to leave the "SQL Server Integration Services" service disabled on all my servers. I need to install it to gain the binaries necessary to run...

opc.three (3/26/2012)

---

I use File System packages and execute them using DTExec from a CmdExec SQL Agent Step Type, not an SSIS Step Type.

I use XML Package Configuration files (.dtsConfig) for...

Thats pretty slick. I revised the 3 SSIS Packages on Friday.

Thanks again.

I noticed an entry for Database Mail failed to start, reason no profile.

But I have a profile.

There are three instances, one of them is disabled and I'm using the other...

There was nothing in the Error log even though there was a corrsponding entry in the windows log at the same time.

I did...