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?