February 16, 2015 at 12:37 pm
Hi, SSIS Expert,
i'm having an issue with a package Execution on MS Visual Studio 2012.
I have a simple SSIS package. the source is Excel source with extension .xlsx on my PC, c: driver.
Database is on an intranet SQL Server 2012 .
All data convertion debugges has been done , however, the last Execution Result shows three main errors:
1. [Excel Source [1028]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.
The AcquireConnection method call to the connection manager "Excel Connection Manager" failed with error code 0xC0202009.
There may be error messages posted before this with more information on why the AcquireConnection method call failed.
2. [SSIS.Pipeline] Error: Excel Source failed validation and returned error code 0xC020801C.
and 3. [SSIS.Pipeline] Error: One or more component failed validation.
Anyway, would you please give me a hint to resolve this Execute error issue?
Helen Wei, Kane County IT
February 17, 2015 at 1:26 am
Apparently the source failed validation.
Aren't there more error messages?
Did the metadata of the excel file change?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 23, 2015 at 2:00 am
If the excel sheet is present on your system and metadata is correct. Try running your package in 32 bit mode.
Right Click Project -> Properties -> Debugging -> Run64bitRuntime to False
____________________________________________________________
APViewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply