April 20, 2017 at 3:13 pm
Good Afternoon Guys,
I am a bit confused and would want to ask for your help as i am having a problem running my SSIS package in SQL Server 2012 that i created from Visual Studio 2015. the scenario is i am fetching Data from An external source which is an Excel 2010 Spreadsheet and trying to put it into a table in sql server. I was able to run it correctly in the VS 2015 by changing the debugging property which is "Run64BitRuntime" and set it to false. when i tried to deploy it in SSMS 2012, and execute it (Went to advanced setting and Check the 32 but Runtime checkbox) and i had the error below.
OnError | 20/04/2017 3:05:31 PM | Load Child Care Subsidy Excel into SQL staging ChildCare_Collections_Summary_and_Stats_ExcelLoad:Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0209302. There may be error messages posted before this with more information on why the AcquireConnection method call failed. | Load Child Care Subsidy Excel into SQL staging ChildCare_Collections_Summary_and_Stats_ExcelLoad | Child Care Subsidy Excel [2] | \ChildCare_Collections_Summary_and_Stats_ExcelLoad\Sequence Container\Load Child Care Subsidy Excel into SQL staging ChildCare_Collections_Summary_and_Stats_ExcelLoad |
OnError | 20/04/2017 3:05:31 PM | Load Child Care Subsidy Excel into SQL staging ChildCare_Collections_Summary_and_Stats_ExcelLoad:Error: Child Care Subsidy Excel failed validation and returned error code 0xC020801C. | Load Child Care Subsidy Excel into SQL staging ChildCare_Collections_Summary_and_Stats_ExcelLoad | SSIS.Pipeline | \ChildCare_Collections_Summary_and_Stats_ExcelLoad\Sequence Container\Load Child Care Subsidy Excel into SQL staging ChildCare_Collections_Summary_and_Stats_ExcelLoad |
OnError | 20/04/2017 3:05:31 PM | ChildCare_Collections_Summary_and_Stats_ExcelLoad:Error: The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. If the 32-bit driver is not installed, run the package in 64-bit mode. Error code: 0x00000000. | ChildCare_Collections_Summary_and_Stats_ExcelLoad | \ChildCare_Collections_Summary_and_Stats_ExcelLoad |
Any Assistance from your end is very much appreciated.
April 20, 2017 at 3:50 pm
Try running in 64 bit mode and see what happens.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
April 21, 2017 at 8:42 am
you can verify that the ACE OLEDB 12 drivers are loaded on the server,
in Control Panel / Programs and Features, look for something named "Microsoft Access database engine" or "Microsoft Office Access database engine", unfortunately it's not as easy to see if 32 bit or 64 bit is installed. If you need to get it, you can get the latest version at:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
April 21, 2017 at 8:53 am
Chris Harshman - Friday, April 21, 2017 8:42 AMyou can verify that the ACE OLEDB 12 drivers are loaded on the server,
in Control Panel / Programs and Features, look for something named "Microsoft Access database engine" or "Microsoft Office Access database engine", unfortunately it's not as easy to see if 32 bit or 64 bit is installed. If you need to get it, you can get the latest version at:
https://www.microsoft.com/en-us/download/details.aspx?id=13255
Opening up the instance in SSMS and looking at Server Objects / Linked Servers / Providers also gives an indication. Not sure how this relates to bitness either.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply