Upgrade file SSIS

• abdalah.mehdoini

  Ten Centuries

  Points: 1019

  More actions

  July 15, 2019 at 1:04 pm

  #3662999

  Hello everyone

  I have two dtx file SSIS develloper EN SSDT 2008 AND I'm going to migrate it in SQL2014

  If I import these files through SSDT 2013 the files are well imported

  

  then if I click on the button upgrade all package

  

  i have this message

  At least one package has to be selected for upgrade.

  

  thank you for your help

• Site Owners

  SSC Guru

  Points: 80332

  More actions

  July 16, 2019 at 1:10 pm

  #3663418

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Jonathan AC Roberts

  SSCoach

  Points: 18394

  More actions

  July 16, 2019 at 1:16 pm

  #3663421

  Have you tried upgrading the files that have been converted to 2013 to 2014 instead of directly migrating the 2008 files?

• latkinson

  SSCommitted

  Points: 1692

  More actions

  July 18, 2019 at 12:52 pm

  #3664131

  I don't have an answer for you, but...

  You might take a look at https://stackoverflow.com/questions/45197675/upgrading-of-ssis-packages-from-2008-to-2014

  It sounds very close to what you are trying to accomplish.

  There is also this article (https://www.mssqltips.com/sqlservertip/4253/backwards-compatibility-in-sql-server-data-tools-for-integration-services/) that provides a nice little bullet list of the SSDT version you need for a particular version of SQL Server and SSIS, in case you have an SSDT version mismatch.

  Luther