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

Home Page Forums Issues – SSIS PowerPack SSIS Errors: The connection type specified for connection manager is not recognized

This topic contains 0 replies, has 1 voice, and was last updated by  ZappySys 4 years, 3 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #1592

    ZappySys
    Keymaster

    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)
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.