SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 paclkage runs in bids but fails sql agent
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shilpash
Yak Posting Veteran

98 Posts

Posted - 06/24/2013 :  11:45:32  Show Profile  Reply with Quote
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.

Please help.

Thanks in advance

Edited by - shilpash on 06/24/2013 13:08:23

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/24/2013 :  12:44:08  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

shilpash
Yak Posting Veteran

98 Posts

Posted - 06/24/2013 :  13:04:41  Show Profile  Reply with Quote
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---


Edited by - shilpash on 06/24/2013 13:05:38
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/24/2013 :  13:35:57  Show Profile  Reply with Quote
yep...And I hope you identified it as config item inside package too (Inside configuration wizard)

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

shilpash
Yak Posting Veteran

98 Posts

Posted - 06/24/2013 :  14:27:28  Show Profile  Reply with Quote
yes I did that too .
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 06/25/2013 :  01:04:27  Show Profile  Reply with Quote
Were you using Dtexec to run it from the job?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000