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 |
|
satish439
Starting Member
6 Posts |
 Posted - 2010-01-29 : 04:31:22
|
| Hi Experts, I created an SSIS package to dump data from excel 2007 sheet to sql server 2008 data base. I have used Microsoft Office 12.0 Access Database Engine database provider as source connection for excel sheet as per my requirement. I have also kept 'Validate External data' property is False for this source and 'Delay Validation' property as True for the data flow task which imports data from excel sheet. My package runs perfectly in solution. But i am getting the below error when trying to run the package through sql server agent JOB.I am surprised why it is throwing error while it is running perfectly in solution. Can any body give solution to my problem.Executed as user: MSLT-109VM3\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 10.0.1600.22 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 9:42:35 PM Error: 2010-01-28 21:42:40.77 Code: 0xC0047062 Source: DFT_Stage Load ADO NET Src_XL Src [1] Description: System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. at System.Data.OleDb.OleDbServicesWrapper.GetDataSource(OleDbConnectionString constr, DataSourceWrapper& datasrcWrapper) at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() 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-01-28 21:42:40.78 Code: 0xC0047017 Source: DFT_Stage Load SSIS.Pipeline Description: component "ADO NET Src_XL Src" (1) failed validation and returned error code 0x80131509. End Error Error: 2010-01-28 21:42:40.78 Code: 0xC004700C Source: DFT_Stage Load SSIS.Pipeline Description: One or more component failed validation. End Error Error: 2010-01-28 21:42:40.79 Code: 0xC0024107 Source: DFT_Stage Load Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:42:35 PM Finished: 9:42:40 PM Elapsed: 5.672 seconds. The package execution failed. The step failed. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-01-29 : 07:28:28
|
System.InvalidOperationException: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.It is a diffenrence between your local PC where the package runs fine and the server on which the package is running from a job.I think there is no installation of Office 12.0 on the server, hence there is the problem.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
satish439
Starting Member
6 Posts |
Posted - 2010-01-29 : 08:15:07
|
| I am not aware of Office 12.0. Is it the new version in MS Office.But i am my JOB and Package runs from same server. If this is the case of installation, then iam surprised how it run successfully from package? |
|
|
|
satish439
Starting Member
6 Posts |
|
|
|
|
|
|
|
SSIS Package Job with error code 0xC0047062