Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

The SSIS package keeps forgetting the password Expand / Collapse
Author
Message
Posted Wednesday, March 06, 2013 11:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 22, 2013 2:08 PM
Points: 19, Visits: 63
I have a SSIS Package that is giving me an error connection

'Test connection failed because of an error in initializing provider. Login failed for user.....

The package does not remember password.

Im connecting to a SQL Server 2005 box using its user_password with sysadmin role.

The SSIS package runs fine when you first set up the connection in bids

The bottom line is that SSIS keeps forgetting the password I feed into
the two Connections that I'm using. I double-click a connection,
type the password in, check "Save my password" and hit "OK" but the
password disappears from there whenever I run the package or
double-click the connection again.

Is anyone know what to do!! please help!! I have a very short time to deploy this package in production.

Post #1427568
Posted Wednesday, March 06, 2013 3:00 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, January 21, 2014 2:45 PM
Points: 262, Visits: 679
The first thing I would check is the Package ProtectionLevel. The appropriate setting for you will be specific to the environment you are running in, but it sounds like you still have it set to DontSaveSensitive - which won't save passwords. For more information, see Setting the Protection Level of Packages.



Rick Krueger

Follow @dataogre
Post #1427654
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse