I am doing a data warehousing project using SQL server for the analysis services database. This service works perfectly, but the problem is with the SQL agent. I created a job to do a daily ETL process with SISS packages. When I try to run that job it returns a configuration error in the connection manager (I bring data from postgre SQL with ODBC). The error it returns is the following (translated with google since it returns it in Spanish):
Code: 0xC020801B Source: Data Flow Task OLE DB Destination [2] Description: Cannot find runtime connection manager with id. "{849459E5-813C-4707-810B-4C5214A362DA}". Check that the connection manager collection has a connection manager with that id. End of error Error: 2020-10-02 11: 12: 00.36 Code: 0xC0047017 Source: SSIS.Pipeline Data Flow Task Description: OLE DB Destination validation failed; error code 0xC020801B was returned.
The question is: how can I change this configuration so that in the connection manager it has the same id that SQL Server mentions?
You need to parameterise the connection within the SSIS designer.
See this article