InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:47:30 GMT20http://www.sqlservercentral.com/Forums/Topic1427568-1292-1.aspxThe 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 [url=http://msdn.microsoft.com/en-us/library/ms141747(v=sql.90).aspx]Setting the Protection Level of Packages[/url].Wed, 06 Mar 2013 15:00:25 GMTRick Kruegerhttp://www.sqlservercentral.com/Forums/Topic1427568-1292-1.aspxI 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 bidsThe bottom line is that SSIS keeps forgetting the password I feed intothe two Connections that I'm using. I double-click a connection,type the password in, check "Save my password" and hit "OK" but thepassword disappears from there whenever I run the package ordouble-click the connection again.Is anyone know what to do!! please help!! I have a very short time to deploy this package in production.Wed, 06 Mar 2013 11:57:49 GMTmontse 22199