SSIS server/pkg upgrade from 2008 to 2017

Nody88 1 Reputation point
2020-03-11T18:37:07.843+00:00

As we are upgrading from 2008 to 2017,
We need to upgrade existing packages to 2017. (we use file store deployment method.) We have 2017 SSDT installed as test environment setup.
While directly opening existing package in 2017 ssdt as a part of upgrade, I am getting error message as consider changing provider in connection manager to sqlncli 11.
All i want to know
1] In order to remove above error and upgrade pkg do i need to make provider changes in connection string and save the updated pkg? OR
2] Can we only change provider in config file only? OR
3] Do I have to make both the above changes to upgrade the pkgs?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,218 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2020-03-12T02:55:09.677+00:00

    QnA currently supports the products listed in right-hand pane (more to be added) Better to reach out to subject matter experts in dedicated forums over here.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?forum=sqlintegrationservices

    (please don't forget to mark helpful replies as answer)

    0 comments