question

PrinceV-3211 avatar image
0 Votes"
PrinceV-3211 asked ZoeHui-MSFT answered

What are the Software requirements for executing SSIS scriptask with SQL server 2019 as target DB

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.

  1. Visual studio version

  2. SSDT version

  3. Dotnet version

  4. Any other softwares needed (e.g: visual c++) or any other settings needed.

  5. what version of sql server 2019 to use. Latest patch update needed or not.

  6. 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




sql-server-integration-services
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

But I am getting error while executing it using SQL Server 2019 sql agent job

And which error message do you get; we can't guess that?
Most often cause are permissions.
What in detail is the package/script doing? Which assemblies is the script task referencing?



0 Votes 0 ·

As Olaf said that error message is useful for us to analyze the issue, we'd suggest that you may provide more details.

0 Votes 0 ·
PrinceV-3211 avatar image
0 Votes"
PrinceV-3211 answered

Hi .. please find the screen-shot. This error is not coming in other server.. I want only the details of correct 95910-screenshot-20210512-171324-whatsapp.jpgsoftwares version required .. for e.g. dotnet version cannot be less than 4.7 for sql server 2019.. etc.,



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered

HI @PrinceV-3211,

You need to compare one particular setting: TargetServerVersion
- on a development workstation in Visual Studio (VS)
vs.
- SQLServer/SSIS run-time environment on a server.

Please see below how it looks like in VS.

96031-ssis-targetserverversion-2.png



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

HI @PrinceV-3211,

SSIS versions are not backwards compatible.

If you want to executing SSIS scrip task with SQL server 2019, you may use VS2019.

download-sql-server-data-tools-ssdt

SQL Server Integration Services Projects

Regards,

Zoe


If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.