question

ajayrawat-5337 avatar image
0 Votes"
ajayrawat-5337 asked YitzhakKhabinsky-0887 commented

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

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

ajayrawat-5337 avatar image
0 Votes"
ajayrawat-5337 answered YitzhakKhabinsky-0887 commented

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/


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

@ajayrawat-5337,

Both Mona and I, told you to install SSIS run-time.
And you are marking your "answer" as answer.

0 Votes 0 ·
YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered

Hi @ajayrawat-5337,

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.


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.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered

Hi @ajayrawat-5337 ,

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.


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.