Script task disappears when SSIS is deployed to SQL Server 2014

• elevy

  Valued Member

  Points: 71

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 247120

  More actions

  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?

  ---

• elevy

  Valued Member

  Points: 71

  More actions

  July 30, 2017 at 7:54 am

  #1953303

  yes