Forum Discussion

AnnW525's avatar
AnnW525
Copper Contributor
Sep 19, 2024

Pipeline Error for SSIS

We are currently upgrading from a SQL 2012 Server to SQL 2022 on Windows Server 2022.  We are using ODBC in SSIS to connect to an AS400 database. Our projects are currently set to a deployment version of SQL 2012.  As long as we don't change that setting, the packages run fine in Visual Studio 2019 with the latest SSIS extension. But, they do not work when deployed to SQL 2022.

 

When we deployed to our SQL 2022 server, or upgraded to a deployment server level of SQL 2019 or 2022 in Visual Studio, we received "Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on xxxxx returned error code 0x80004005..."   All parts of the data flow task have green check marks, but the DFT as a whole fails and the error is in the Progress tab. 

 

Any ideas on what we can do to get this to work on our new server?

 

If we add a source without a destination, it doesn't error out.  As soon as we add any destination, the error occurs when deployed or when the project deployment server is set to SQL 2019 or higher. This makes sense to me since the pipeline probably isn't initiated until a destination is added. 

No RepliesBe the first to reply

Resources