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

[ZappySysKeymaster]

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)

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)

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)

[Author]

Posts