SSIS package not running outside of SQL Server Data Tools

Question

I have SSIS Package created in 2008. I opened the package in Visual studio 2017 and updated the TargetServerVersion as 2012.

SQL Server Database version: 2019
SSMS installed version: 2012

When i run the package in Viusal studio I am not getting any error. But when I run the package via batch file using the dtexec command i am getting error.

Error:

Error: 2021-10-26 11:06:11.26
Code: 0xC000F427
Source: Send Mail Task
Description: To run a SSIS package outside of SQL Server Data Tools you must
install Send Mail Task of Integration Services or higher.
End Error

The package has script task and data flow task and is failing. Only Execute SQL task is running without any issues.
Please update me the reason for failing in dtexec command alone when it is running fine in Visual studio.

Answer 1

Hi @Thirukkalaikumar Palanisamy ,

May I know if you have installed install-integration-services?

You may check below link to see if it is helpful.

https://stackoverflow.com/questions/43137008/to-run-ssis-package-outside-of-sql-server-data-tools-you-must-install-file-creat

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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

Answer 2

I have installed SSDT as shown below while installing Visual studio.

Then installed below:

Download SSDT for Visual Studio 2017(15.9.9) from the below link.
https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-ver15&viewFallbackFrom=sql-server-ver15%20

I am using Package deployment model and not deployed the package in SQL server. Just running the package using dtexec cmd from my local (not from the server where sql server db instance is installed).

Do I need to use 64 bit dtexec cmd ? I do not have that currently.

Answer 3

Hi Zoehui,

The package has script task and data flow task and is failing. Only Execute SQL task is running without any issues. If integration service is not install (above screen) then unable to execute any SSIS component via batch file using the dtexec command.Kindly help me.

Answer 4

Hi @Thirukkalaikumar Palanisamy ,

Please help check that the TargetServerVersion is 2017 for you have installed SSIS2017.

Your system may have more than one version of dtexec, make sure you are choosing version 140 as said here.

Here is a same issue as yours, you could take a reference for the resolutions.

ssis-error-to-run-a-ssis-package-outside-of-sql-server-data-tools-you-must-inst

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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

Answer 5

I am running dtexec command from VDI where I have installed SSDT, VS and SSMS. So looks like I need to install Integration Services (Shared feature) shown below in SQL server instance (server where the actual sql server database is installed).

Is it correct understanding ?