Package Validation Error- failed validation and returned error code 0xC004800B

Question

TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at dfImportData [SSIS.Pipeline]: Cannot find the connection manager with ID "{D9F5E117-B143-40BA-8FB6-7DC8F3095382}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "runtime connection "OleDbConnection" (8)" in the connection manager collection of "component "Excel Source" (1)". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID.

Error at dfImportData [SSIS.Pipeline]: component "Excel Source" (1) failed validation and returned error code 0xC004800B.

Error at dfImportData [SSIS.Pipeline]: One or more component failed validation.

Error at dfImportData: There were errors during task validation.

 (Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------

Answer 1

go to the data flow task and then to the Excel Source and change the connection manager. It looks like you deleted the connection manager with guid {D9F5E117-B143-40BA-8FB6-7DC8F3095382}

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 2

Add, Delete, or Share a Connection Manager in a Package
http://msdn.microsoft.com/en-us/library/ms140237.aspx

---

If you have found any of my posts helpful then please vote them as helpful. Kieran Patrick Wood MCTS BI,MCC, PGD SoftDev (Open), MBCS http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood