Package Validation Error

2019-05-20 15:06发布

I'm trying to use a foreach loop container to import several excel files into a table, I specified the folder and the files I'm going to use (*.xls), after that I created a path variable then I went to the excel source connection and in the "Expression" property I selected the variable. I created the foreach container but, the excel source's connectionString only shows Provider=Microsoft.Jet.OLEDB.4.0;, so it means it's not taking the variable value. What can I do to solve that?

Note: I'm using SQL Server 2012

ADDITIONAL INFORMATION:

Error at Data Flow Task [Excel Source [20]]: 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.

Error at Data Flow Task [SSIS.Pipeline]: Excel Source failed validation and returned error code 0xC020801C.

Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.

Error at Data Flow Task: There were errors during task validation.

Error at Package [Connection manager "Excel Connection Manager"]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.

(Microsoft.DataTransformationServices.VsIntegration)

2条回答
够拽才男人
2楼-- · 2019-05-20 15:28

Check the link below where I answer mainly focus on RUN64BITS TO FALSE instead of TRUE.

Execel Source ERROR

查看更多
时光不老,我们不散
3楼-- · 2019-05-20 15:41

Running a SQL 2012 SSIS Package via an MVC Website fails with:

The Script Task is corrupted.

and

There were errors during task validation.

Runs perfectly from with in BIDS.


To resolve it I set the Project Property:

Run64BitRunTime = False  
Security = DontSaveSensitive

In the Package I set:

DelayValidation = True
Security = DontSaveSensitive

This still failed. I came across this which indicates that Script Tasks are the problem.

So I removed the script task and it worked straight away.

查看更多
登录 后发表回答