CODEWITHSUNDEEP
excelssisetlsql-server-data-toolsssis-2017
Sharan G
Sharan G

Reputation: 55

Error: Excel Destination.Connections[OleDbConnection] does not have a value for the ID property

I want to write the data from SQL server in Excel destination. When executed the Data Flow Task gets failed due to these error:

[SSIS.Pipeline] Error: The "Excel Destination.Connections[OleDbConnection]" in the connection manager collection, Connections, of "Excel Destination" does not have a value for the ID property. Verify that the ConnectionManagerID property of the runtime connection object has been set for the component.

[SSIS.Pipeline] Error: Excel Destination failed validation and returned error code 0xC004801C.

I have set the Delay Validation property of the package to TRUE

Upvotes: 2

Views: 1973

Answers (2)

jmdeamer
jmdeamer

Reputation: 335

I resolved a similar 'does not have a value for the ID property' error by closing the destination Excel file associated with the connection, which was open on the desktop.

Error string details.

Error at Data Flow Task [SSIS.Pipeline]: The "OData Source.Connections[Connection]" in the connection manager collection, Connections, of "OData Source" does not have a value for the ID property. Verify that the ConnectionManagerID property of the runtime connection object has been set for the component.

Upvotes: 0

Hadi
Hadi

Reputation: 37313

This exception occurs when you didn't specify a connection manager for the Excel Destination. Double click on the Excel Destination, there is a property called Excel Connection Manager which allow selecting an existing Excel connection manager from the list, or creating a new connection by clicking New.

enter image description here

For more information on how to import data to Excel you can refer to the following links:

Similar Issue link

Upvotes: 2

Related Questions