Forum Discussion
seanroussy
Feb 28, 2024Copper Contributor
Does Application.Upgrade work in Microsoft.SQLServer.ManagedDTS.dll version 16 (SSIS 2022)
So I have thousands of SSIS packages. In the pas I have installed the new SSIS components and written a little dotNet script to upgrade all of the low hanging fruit real fast. I see that the required dll Microsoft.SQLServer.ManagedDTS.dll did ship with the new SSIS and after making sure my reference paths were pointing to the new version I am getting alot of upgrade failure and System Not Supported exceptions and when I go to the SQL Server documentation for Application.Upgrade it does not have SQL Server 2022 in the drop down box. Now I am left with the sinking feeling I have a lot terrible manual repetitive work ahead of me. Why was this deprecated?
No RepliesBe the first to reply