Post reply

Script task disappears when SSIS is deployed to SQL Server 2014

  • July 30, 2017 at 2:00 am

    #322913

    When I compile and deploy the project to SQL Server 2012 (SSIS version 6) everything works as expected. But when I compile and deploy the project to SQL Server 2014 (SSIS version updates to 8) all the script tasks disappears.
    when I pre-build the project in SSIS to suit SQL Server 2014 (SSIS version 8), it works. I just want to understand if I'm going to need to have 2 versions ready at all times.
    Has anyone encountered this type of behavior? Am I doing something wrong?
    Please help

  • July 30, 2017 at 7:36 am

    #1953302

    elevy - Sunday, July 30, 2017 2:00 AM

    When I compile and deploy the project to SQL Server 2012 (SSIS version 6) everything works as expected. But when I compile and deploy the project to SQL Server 2014 (SSIS version updates to 8) all the script tasks disappears.
    when I pre-build the project in SSIS to suit SQL Server 2014 (SSIS version 8), it works. I just want to understand if I'm going to need to have 2 versions ready at all times.
    Has anyone encountered this type of behavior? Am I doing something wrong?
    Please help

    Are you deploying from SSDT 2015?

  • July 30, 2017 at 7:54 am

    #1953303

    yes

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply