I have an SSIS project built in Visual Studio 2022 and consists of several packages. They all interrogate a source SQL server database and update a destination SQL server database (both 2016). These packages all run successfully from visual studio and do exactly what is required. I have deployed them to the Catalogue and now tried running them but all seem to state failed in the SQL Server Package report with dozens of error messages - too many to list here. The first error message though is always "The package cannot execute because it contains tasks that failed to load".
What is wrong here please? I have had a search for the first error message and other search inputs and some state it is a licensing issue but no other information. The only thing of note I changed when deploying is in the properties of the "project" I enabled windows authentication and selected SQL server version as 2017 (there was no 2016)
1条答案
按热度按时间6yt4nkrj1#
It is a limitation of earlier versions of the "SQL Server Integration Services Projects 2022" for VS2022.
As many already pointed out, you need to install "SQL Server Integration Services Projects 2022" v.1.2.
Release Notes
Version 1.2
- SQL server 2016 is supported as target server version.
Here is its download link: SQL Server Integration Services Projects 2022
NOTE from Question Poster - This worked but also had to ensure latest Visual C++ Redistributable was installed and link below for OLE DB 18.6.7 version because 19.3.1 did not work. Also installed .NET Framework 4.8
https://learn.microsoft.com/en-us/sql/connect/oledb/release-notes-for-oledb-driver-for-sql-server?view=sql-server-ver16#1867