I have a package which is getting source from sybase using the connection that has username and password.Package runs fine but while scheduling it from sql agent,it fails even with proxy account.
Description: Microsoft.SqlServer.Dts.Runtime.DtsCouldNotCreateManagedConnectionException: Could not create a managed connection manager. at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction) at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager100.AcquireConnection(Object pTransaction) at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction) at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper100 wrapper, Object transaction) End Error Error: 2013-06-24 10:39:30.27 Code: 0xC0047017
I also tried using 32 bit in execution option.Same error though. I tried using configuration file in xml and giving the password in password option as well.Same error.
Have you added the password as a configuration item and passed value through it? The default setting will not store any sensitive properties within the SSIS package. Thats why you need to add it as a configuration item.