Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shilpash
Posting Yak Master
103 Posts |
 Posted - 2013-06-24 : 11:45:32
|
| 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: 0xC0047017I 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.Please help.Thanks in advance |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-24 : 12:44:08
|
| 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.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
shilpash
Posting Yak Master
103 Posts |
Posted - 2013-06-24 : 13:04:41
|
| Hi Visakh,Thank you for your response.I have added a password as a configuration item.I opened that config file and supplied a value in -- <Configuration ConfiguredType="Property" Path="\Package.Connections[copath.sa].Properties[Password]" ValueType="String"> <ConfiguredValue>xxxxxxx</ConfiguredValue>This is the only part where I change in that config file.Don't know if I am missing some other--- |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-24 : 13:35:57
|
| yep...And I hope you identified it as config item inside package too (Inside configuration wizard)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
shilpash
Posting Yak Master
103 Posts |
Posted - 2013-06-24 : 14:27:28
|
| yes I did that too . |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-25 : 01:04:27
|
| Were you using Dtexec to run it from the job?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
paclkage runs in bids but fails sql agent