I am able to run this via Management Studio when connected to the Integration Services server but am unable to run this via the SQL Server Agent. This connection is to a 10g server via the ADO.net 11g drivers. Any help would be greatly appreciated. :) I have the package set to not store sensitive and have created a configuration file that contains the server, user name and password for the database. Thanks, Chris Date 12/15/2010 11:52:35 AM Log Job History (****) Step ID 1 Server ***** Job Name ***** Step Name Push Data Duration 00:00:05 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:52:35 AM Error: 2010-12-15 11:52:40.40 Code: 0xC0047062 Source: Data Flow Task query Ad-Juster upload file 1 [8] 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: 2010-12-15 11:52:40.40 Code: 0xC0047017 Source: Data Flow Task SSIS.Pipeline Description: component "query Ad-Juster upload file 1" (8) failed validation and returned error code 0x80131500. End Error Error: 2010-12-15 11:52:40.40 Code: 0xC004700C Source: Data Flow Task SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-12-15 11:52:40.40 Code: 0xC0024107 Source: Data Flow Task Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:52:35 AM Finished: 11:52:40 AM Elapsed: 4.578 seconds. The package execution failed. The step failed.

Perhaps its a problem with 32bit Managament Studio and 64bit at SQL Server Agent runtime.

Hi Make sure that the account that you're running SQL Agent under has access to your configurations. J MCITP BI Developer 2008 - MCTS SQL Server 2005

I am running on a 64 bit machine with SQL 2008 R2 64 bit installed. I have also installed the Oracle 11g 64 bit ADO.net Drivers.

Just as a test I gave Everyone access to do EVERYTHING on the server and still came up with that error.

How exactly are you running this job "manually" (when it works)? Are you running SSMS on your local machine, connecting to the server, and right-click "Execute"-ing it? Talk to me now on

I am RDPing into the server and connecting via SSMS to the Integration server. From there I "Run Package" and associate the configuration file with it before executing it. This scenerio works. The scenerio that does not work is when I connect to the SQL Server instance and try and execute a job that has only one step in it which is to execute the package stored in the MSDB.

The error suggests that this is not a "regular" type of permissions error. It doesn't have a problem opening the package, and isn't claiming that credentials for contacting the database aren't valid. It is stating that it can't create a connection manager. To me, this implies that it can't start up the Oracle driver for some reason. Usually I'd say this is a bitness issue, but it doesn't sound like it from what you've tried. So - try this... go through both routes one more time - the one that works and the one that doesn't. When you try to execute it manually, just before you execute, go to the last page of the "wizard". It's the "command line" tab. Copy that text out. Go to your Agent job, edit that job step, and go to the same last page - the "command line" tab. If they're different, post them up here. If they're not different, do you have a Proxy executing the Agent Job? If you don't, create a proxy for your own account, attach it to the Job, and try executing it. Talk to me now on

The error suggests that this is not a "regular" type of permissions error. It doesn't have a problem opening the package, and isn't claiming that credentials for contacting the database aren't valid. It is stating that it can't create a connection manager. To me, this implies that it can't start up the Oracle driver for some reason. Usually I'd say this is a bitness issue, but it doesn't sound like it from what you've tried. So - try this... go through both routes one more time - the one that works and the one that doesn't. When you try to execute it manually, just before you execute, go to the last page of the "wizard". It's the "command line" tab. Copy that text out. Go to your Agent job, edit that job step, and go to the same last page - the "command line" tab. If they're different, post them up here. If they're not different, do you have a Proxy executing the Agent Job? If you don't, create a proxy for your own account, attach it to the Job, and try executing it. Talk to me now on /DTS "\MSDB\AdJusterUpload" /SERVER {servername} /CONFIGFILE "D:\PackageConfigurations\AdJusterUpload.dtsx.dtsConfig" /CHECKPOINTING OFF /REPORTING V /DTS "\MSDB\AdJusterUpload" /SERVER {servername} /CONFIGFILE "D:\PackageConfigurations\AdJusterUpload.dtsx.dtsConfig" /CHECKPOINTING OFF /REPORTING E Only difference appears to be the reporting attribute. Will try the proxy and let you know how it works. Thank you for all the suggestions.

Try the proxy step - the reporting difference doesn't look significant. Talk to me now on

Try the proxy step - the reporting difference doesn't look significant. Talk to me now on Below are both of the errors from running it as SQL agent or me as a proxy. You can tell by the "Executed as user:" section. I am an admin on the box as well as an admin on the SQL server. Any other thoughts? This is killing me. **************** SQL Agent ************* Date 12/16/2010 11:08:18 AM Log Job History (AdJuster) Step ID 1 Server ************ Job Name AdJuster Step Name Push Data Duration 00:00:07 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:08:18 AM Error: 2010-12-16 11:08:24.83 Code: 0xC0047062 Source: Data Flow Task Plus query Ad-Juster upload file [1] 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: 2010-12-16 11:08:24.84 Code: 0xC0047017 Source: Data Flow Task Plus SSIS.Pipeline Description: component "query Ad-Juster upload file" (1) failed validation and returned error code 0x80131500. End Error Error: 2010-12-16 11:08:24.86 Code: 0xC004700C Source: Data Flow Task Plus SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-12-16 11:08:24.86 Code: 0xC0024107 Source: Data Flow Task Plus Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:08:18 AM Finished: 11:08:24 AM Elapsed: 6.547 seconds. The package execution failed. The step failed. ****************** Proxy (ME) ******************** Date 12/16/2010 11:10:25 AM Log Job History (AdJuster) Step ID 1 Server ************ Job Name AdJuster Step Name Push Data Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: UOL\cquinn. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:10:25 AM Error: 2010-12-16 11:10:26.56 Code: 0xC0047062 Source: Data Flow Task Plus query Ad-Juster upload file [1] 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: 2010-12-16 11:10:26.56 Code: 0xC0047017 Source: Data Flow Task Plus SSIS.Pipeline Description: component "query Ad-Juster upload file" (1) failed validation and returned error code 0x80131500. End Error Error: 2010-12-16 11:10:26.56 Code: 0xC004700C Source: Data Flow Task Plus SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-12-16 11:10:26.56 Code: 0xC0024107 Source: Data Flow Task Plus Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:10:25 AM Finished: 11:10:26 AM Elapsed: 0.703 seconds. The package execution failed. The step failed.

Try the proxy step - the reporting difference doesn't look significant. Talk to me now on Below are both of the errors from running it as SQL agent or me as a proxy. You can tell by the "Executed as user:" section. I am an admin on the box as well as an admin on the SQL server. Any other thoughts? This is killing me. **************** SQL Agent ************* Date 12/16/2010 11:08:18 AM Log Job History (AdJuster) Step ID 1 Server ************ Job Name AdJuster Step Name Push Data Duration 00:00:07 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: NT AUTHORITY\NETWORK SERVICE. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:08:18 AM Error: 2010-12-16 11:08:24.83 Code: 0xC0047062 Source: Data Flow Task Plus query Ad-Juster upload file [1] 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: 2010-12-16 11:08:24.84 Code: 0xC0047017 Source: Data Flow Task Plus SSIS.Pipeline Description: component "query Ad-Juster upload file" (1) failed validation and returned error code 0x80131500. End Error Error: 2010-12-16 11:08:24.86 Code: 0xC004700C Source: Data Flow Task Plus SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-12-16 11:08:24.86 Code: 0xC0024107 Source: Data Flow Task Plus Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:08:18 AM Finished: 11:08:24 AM Elapsed: 6.547 seconds. The package execution failed. The step failed. ****************** Proxy (ME) ******************** Date 12/16/2010 11:10:25 AM Log Job History (AdJuster) Step ID 1 Server ************ Job Name AdJuster Step Name Push Data Duration 00:00:01 Sql Severity 0 Sql Message ID 0 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: UOL\cquinn. Microsoft (R) SQL Server Execute Package Utility Version 10.50.1600.1 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 11:10:25 AM Error: 2010-12-16 11:10:26.56 Code: 0xC0047062 Source: Data Flow Task Plus query Ad-Juster upload file [1] 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: 2010-12-16 11:10:26.56 Code: 0xC0047017 Source: Data Flow Task Plus SSIS.Pipeline Description: component "query Ad-Juster upload file" (1) failed validation and returned error code 0x80131500. End Error Error: 2010-12-16 11:10:26.56 Code: 0xC004700C Source: Data Flow Task Plus SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-12-16 11:10:26.56 Code: 0xC0024107 Source: Data Flow Task Plus Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:10:25 AM Finished: 11:10:26 AM Elapsed: 0.703 seconds. The package execution failed. The step failed.

Have you tried explicitly running it in 32-bit mode? (Just trying to rule out a 64-bit issue.) Do I also notice that you're using CozyRoc's Data Flow Task Plus? You may want to run a test with a native Data Flow Task or Execute SQL Task against that connection manager to make sure it's not their stuff. Talk to me now on

Have you tried explicitly running it in 32-bit mode? (Just trying to rule out a 64-bit issue.) Do I also notice that you're using CozyRoc's Data Flow Task Plus? You may want to run a test with a native Data Flow Task or Execute SQL Task against that connection manager to make sure it's not their stuff. Talk to me now on

Hi, Does "query Ad-Juster upload file" this mean you have some file connection manager? If so try giving the absolute path rather than network path. As SQL Server Agent understands only absolute path.