SQL Server Having issue running SSIS script task in Visual Studio with 2019 as target version

cl25kdpy  于 2023-03-07  发布在  其他
关注(0)|答案(1)|浏览(120)

We are upgrading from Sqlserver 2012 to 2019 in that process we need to migrate our SSIS packages also from 2012 to 2019. We have lot of script task which uses connection string and other configurations from DtsDebugHost.exe.config It was loaded from Binn folder of Sql server installation folder by default in sql server 2012. but in sqlserver 2019 we couldn't figure out from where it is loaded to the appdata local folder. So our script task is failing because it couldn't acquire connection and couldn't resolve the libraries ( which are used in our config).

55ooxyrt

55ooxyrt1#

For someone who's interested in this question, the file is at somewhere like this C:\Users\yourUsername\AppData\Local\Microsoft\Microsoft SQL Server\150\SSIS\ApplocalConfigs

相关问题