question

ThirukkalaikumarPalanisamy-2416 avatar image
0 Votes"
ThirukkalaikumarPalanisamy-2416 asked ZoeHui-MSFT commented

SSIS package not running outside of SQL Server Data Tools

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.

143931-image.png



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.

sql-server-integration-services
image.png (2.8 KiB)
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 @ThirukkalaikumarPalanisamy-2416,

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


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.

ThirukkalaikumarPalanisamy-2416 avatar image
0 Votes"
ThirukkalaikumarPalanisamy-2416 answered ZoeHui-MSFT commented

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

144155-image.png


Then installed below:

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

144080-image.png


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

144057-image.png



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


image.png (49.3 KiB)
image.png (57.9 KiB)
image.png (6.3 KiB)
· 1
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.

Hi @ThirukkalaikumarPalanisamy-2416,

You need to install SSIS run-time before you can execute SSIS packages outside of Visual Studio. Please have a double check.
144351-screenshot-2021-10-28-092837.jpg

Check this link.

0 Votes 0 ·
ThirukkalaikumarPalanisamy-2416 avatar image
0 Votes"
ThirukkalaikumarPalanisamy-2416 answered ThirukkalaikumarPalanisamy-2416 commented

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.

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

Hi @ThirukkalaikumarPalanisamy-2416,
You cannot run packages outside SQL Server Data Tools on a client computer that does not have Integration Services installed. So please install integration service as shown above in your machine, and then run the package via dtexec command.

0 Votes 0 ·

Hi Zoehui,

I have installed the Integration Service 2017.


144606-image.png


Now configuration are sysc :

SQL Server 2017, Visual Studio 2017, and SSDT version : 15.9.9 but i got same issue.

Error: 2021-10-28 09:19:29.29
Code: 0xC000F427
Source: Send Mail Task
Description: To run a SSIS package outside of SQL Server Data Tools you must
install Standard Edition of Integration Services or higher.
End Error
Error: 2021-10-28 09:19:29.29
Code: 0xC000F427
Source: Load fttFactSettleTrades SSIS.Pipeline
Description: To run a SSIS package outside of SQL Server Data Tools you must
install Standard Edition of Integration Services or higher.
End Error

0 Votes 0 ·
image.png (14.2 KiB)
ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @ThirukkalaikumarPalanisamy-2416,

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

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.

ThirukkalaikumarPalanisamy-2416 avatar image
0 Votes"
ThirukkalaikumarPalanisamy-2416 answered ZoeHui-MSFT commented

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 ?

144799-image.png



image.png (242.0 KiB)
· 1
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.

Hi @ThirukkalaikumarPalanisamy-2416,

Right that you need to install SSIS run-time in your machine before you can execute SSIS packages outside of Visual Studio.

See here about the installation steps.

0 Votes 0 ·