SSIS Errors: The connection type specified for connection manager is not recognized

[ZappySys]

Error:

The connection type "ZS-AWS-REDSHIFT" specified for connection manager "Amazon Redshift" is not recognized as a valid connection manager type

— OR —

Package is working fine Visual Studio but does not work when run inside SQL Agent Job (Integration Services Server Component)

— OR —

Cannot find the connection manager with ID “{xxxxxxxx-xxxx-xxx-xxxx-xxxxxxxxxx}” in the connection manager collection due to error code 0xC0010009.

Cause:

This can happened due to one of the following reasons.

1. SSIS PowerPack Components/Tasks not correctly installed or its totally missing on the machine where you are trying to run SSIS Package.
2. You recently installed or upgraded SSIS PowerPack but did not restart Integration Services (Start | All Programs | Microsoft SQL Server 2012 | Configuration Tools | SQL Server Configuration Manager)
3. Deploying the partial or corrupted SSIS Package, Occasionally, when deploying from the repository.

Solution:

1. Install SSIS PowerPack if its missing on the machine where you are trying to run SSIS Package.
2. Restart Integration Services (Start | All Programs | Microsoft SQL Server 2012 | Configuration Tools | SQL Server Configuration Manager)
3. Please ensure you deploy the package completely and correctly. Occasionally, when deploying from the TFS repository, there’s a risk of the package becoming corrupted. We recommend deploying the SSIS package directly from Visual Studio.

[Author]

Posts