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).
1条答案
按热度按时间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