Getting error : to run a ssis package outside of sql server data tools you must install standard edition (64-bit) of Integration Services or higher

Question

Hi Everyone,

I developed a package in SSIS 2019, and now testing it by running it from the batch file getting an error: to run a ssis package outside of sql server data tools you must install standard edition (64-bit) of Integration Services or higher.

If i am running it from BIDS its running fine.

Thanks.

Answer 1

Thanks All for help Issue got resolved by installing SSIS services.
Below is the Link that helped me .

https://www.mssqltips.com/sqlservertip/6635/install-ssis/

Answer 2

Hi @ajay rawat ,

You need to install SSIS run-time before you can execute SSIS packages outside of Visual Studio.

Overall, SSIS has two principal environments:

• Development, on a development workstation in Visual Studio (VS) with SSDT for VS 2017 or SQL Server Integration Services Projects extension for VS2019: SQL Server Integration Services Projects.
• Run-time, on a server with SSIS run-time installed, plus a license for MS SQL Server instance.

Answer 3

Hi @ajay rawat ,

1.May I know if you download SQL Server and install Integration Services (SSIS)?

2.Could you please share the example of your batch file?

Best regards,
Mona

---

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.

Answer 4

Hello. When I run this batch file, that will execute an SSIS package, it shows this error:

Batch file:
del "%~dp0\logs\AutoEmail Receiver.log"

set log="%~dp0\logs\AutoEmail Receiver.log"

set master="%~dp0AutoEmail Receiver\AutoEmail Receiver.dtsx"

"C:\Program Files (x86)\Microsoft SQL Server\120\DTS\Binn\DTExec.exe" /F %master% /REPORTING EWCDI >> %log%

pause

Error log:

Microsoft (R) SQL Server Execute Package Utility

Version 12.0.2000.8 for 64-bit

Copyright (C) Microsoft Corporation. All rights reserved.

Started: 3:48:14 AM

Error: 2024-07-01 03:48:15.56

Code: 0xC000F427

Source: Execute Payroll Batch File

Description: To run a SSIS package outside of SQL Server Data Tools you must install Execute Payroll Batch File of Integration Services or higher.

End Error

Can someone help me to fix this issue? I am running VS2015 and SQL Server 2014