Hi, I got a strange problem. I have developed a package that reads data from Excel into Sql Server 2012. The package runs with success in SQL Server Data Tools but when I try to schedule the package in Agent i get this error message. Description: The connection is not found. This error is thrown by Connections collection when the specific connection element is not found. I think it is the Ole db destination that makes this error. When i create the step in Agent, on the Data Source tab only the excel connection manager is shown. Why not the Ole db destination? This destiantion is a project data source, is there something else that needs to be configured? Thanks in advanced!

Hi Perwi, Can you provide the full error information.. First thing save your package ,close BIDS instance.. try executing job

Yes, I deleted some information, OLE_DST_ReadNews is the OLE DB Destination. Executed as user: MSBI\Administrator. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:32:25 AM Error: 2012-07-25 11:32:25.86 Code: 0xC001000E Source: Description: The connection "{DAC70E6F-5796-44F8-A36C-CF5F27EDF984}" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2012-07-25 11:32:25.86 Code: 0xC001000E Source: Description: The connection "{DAC70E6F-5796-44F8-A36C-CF5F27EDF984}" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2012-07-25 11:32:25.87 Code: 0xC001000E Source: Description: The connection "{DAC70E6F-5796-44F8-A36C-CF5F27EDF984}" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2012-07-25 11:32:25.87 Code: 0xC001000E Source: Description: The connection "{DAC70E6F-5796-44F8-A36C-CF5F27EDF984}" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2012-07-25 11:32:25.87 Code: 0xC001000E Source: Description: The connection "{DAC70E6F-5796-44F8-A36C-CF5F27EDF984}" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2012-07-25 11:32:25.95 Code: 0xC001000E Source: Description: The connection "{DAC70E6F-5796-44F8-A36C-CF5F27EDF984}" is not found. This error is thrown by Connections collection when the specific connection element is not found. End Error Error: 2012-07-25 11:32:25.95 Code: 0xC004800B Source: Description: Cannot find the connection manager with ID "{DAC70E6F-5796-44F8-A36C-CF5F27EDF984}" in the connection manager collection due to error code 0xC0010009. That connection manager is needed by "OLE_DST_ReadNews.Connections[OleDbConnection]" in the connection manager collection of "OLE_DST_ReadNews". Verify that a connection manager in the connection manager collection, Connections, has been created with that ID. End Error Error: 2012-07-25 11:32:25.95 Code: 0xC0047017 Source: Description: failed validation and returned error code 0xC004800B. End Error Error: 2012-07-25 11:32:25.95 Code: 0xC004700C Source: Description: One or more component failed validation. End Error Error: 2012-07-25 11:32:25.95 Code: 0xC0024107 Source: Description: There were errors during task validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 11:32:25 AM Finished: 11:32:25 AM Elapsed: 0.188 seconds. The package execution failed. The step failed.

I believe you are passing connection string from a parameter Open the package and edit the component where ever you are specifying connections, some where you could have missed to map the approriate connection.. Do it with some patience ;).

I dont think so. I have no configuration or expression for the data source. It looks like this: http://s17.postimage.org/8wi6jl62n/Untitled.jpg Or did I missunderstand you? StockDatabaseDW is the only data source this package is using, except the excel connection manager. I cant understand what the problem is. In SSIS 2012, has something changed about project data source?