question

pandi.par2008 avatar image
pandi.par2008 asked

Excel Source validation Failed

I am trying to load the data from excel to sql. I have set the OpenRowSet as "Scorecard$B4:CU" in Excel Source Properties. When I execute this data flow task I get the following error. Start, 3:11:55 PM Validation has started [SSIS.Pipeline] Information: Validation phase is beginning. Progress: Validating - 0 percent complete [Excel Source [2]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "CDW Tiered Pricing Dashboard" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed. [SSIS.Pipeline] Error: Excel Source failed validation and returned error code 0xC020801C. Progress: Validating - 33 percent complete [SSIS.Pipeline] Error: One or more component failed validation. Error: There were errors during task validation. Validation is completed. Finished, 3:11:59 PM, Elapsed time: 00:00:04.969
ssis errorssis2012excel-connection
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
tzvikl avatar image
tzvikl answered
Hi Make sure your'e running the package in 32bit mode and 64bit, Excel sources in SSIS work only in 32 bit mode, you can see this configuration under the project properties window (right click on the project ->properties ->Debugging -> Run64BitRuntime -> set this to false)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.