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

ajay rawat 116 Reputation points
2021-04-14T21:07:51.09+00:00

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,575 questions
0 comments
Accepted answer
  1. ajay rawat 116 Reputation points
    2021-04-16T00:24:52.927+00:00

    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/

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 25,856 Reputation points
    2021-04-15T01:41:43.94+00:00

    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.
    0 comments
  2. Monalv-MSFT 5,901 Reputation points
    2021-04-15T08:50:14.697+00:00

    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.

    0 comments
  3. Kim Anical 0 Reputation points
    2024-07-01T13:56:28.59+00:00

    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

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.