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,450 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/

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Yitzhak Khabinsky 24,936 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,891 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