Viewing 15 posts - 1,636 through 1,650 (of 3,738 total)
All of the steps in the second job failed with the same error.
All three packages protection level property is set to EncryptSensitiveWithUserKey.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 4:20 pm
Lynn Pettis (3/26/2012)
Welsh Corgi (3/26/2012)
I have a job that executes 4 pages.
The last one fails with an invalid password.
I execute the Package...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 4:13 pm
Lynn Pettis (3/26/2012)
Welsh Corgi (3/26/2012)
I have a job that executes 4 pages.
The last one fails with an invalid password.
I execute the Package...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 4:03 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 3:49 pm
sqlserver8650 (3/26/2012)
Hi,Click the check box(Save password) in connection managers of corrsponding connection
I did not see a check box (Save password).
I checked alllow saving password, redeployed and the job failed.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 2:57 pm
sqlserver8650 (3/26/2012)
Hi,Click the check box(Save password) in connection managers of corrsponding connection
That's odd, I wonder why it saved the PW for the other 3 packages in the job.
I will...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 2:53 pm
Lynn Pettis (3/26/2012)
I did not save sensitive Data.
This means the package does not have the password to connect. Are you passing this in via a package configuration?
Just got out...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 2:52 pm
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 1:28 pm
I just noticed that you can't go into design view if you store the SSIS Package in MSDB?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 12:50 pm
Yes, of course BOL.:blush:
Thanks for the link to the video.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 11:56 am
opc.three (3/26/2012)
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 11:08 am
opc.three (3/26/2012)
I use XML Package Configuration files (.dtsConfig) for...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 11:06 am
Thats pretty slick. I revised the 3 SSIS Packages on Friday.
Thanks again.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 11:01 am
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...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 10:53 am
Lynn Pettis (3/26/2012)
Anything in SQL Server error log?
There was nothing in the Error log even though there was a corrsponding entry in the windows log at the same time.
I did...
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
March 26, 2012 at 10:48 am
Viewing 15 posts - 1,636 through 1,650 (of 3,738 total)