Hi Team
I have developed SSIS package(with script task) using visual studio 2015 (SSDT 2015). But I am getting error while executing it using SQL Server 2019 sql agent job. I want to know what are the prerequisites for successful execution. This package is working fine in one server but failing in another server. I am using xml configuration file and file deployment method. Please let me know the correct version of softwares required for executing ssis package in 2019 SQL server job.
Visual studio version
SSDT version
Dotnet version
Any other softwares needed (e.g: visual c++) or any other settings needed.
what version of sql server 2019 to use. Latest patch update needed or not.
script task version(if any)
If someone can provide the correct link to download these softwares it will be very helpful.
Thanks in advance
Prince
softwares version required .. for e.g. dotnet version cannot be less than 4.7 for sql server 2019.. etc.,