Run SSIS Package Without SQL Server Integration Services

Question

Can we run SSIS Package without integration services? If Yes then what are the steps? If No then what is the minimum requirement.

The problem statement is as follow:

I am using SQL Azure database to store the data. I also have Azure VM from which I need to schedule SSIS Packages. In this Azure VM we don't have Integration Services Installed. My approach is to schedule the SSIS package using batch file in windows scheduler.

I have gone through various threads and posts regarding this but didn't get the correct answer.

Answer 1

You cannot run a SSIS package (.dtsx) without installing the SQL Server integration Services. The minimum requirements are the SSIS client tools and the DTEXEC utility so you must install the Integration Services shared feature from the SQL Server install media.

References

• Run SSIS package in a machine without Sql Server
• Ways to execute SSIS package
• Running an SSIS package without the SSIS service installed
• https://www.sqlshack.com/ways-use-execute-sql-server-integration-services-packages/

Answer 2

As mentioned in a comment, you can avoid a full install of SQL server if you use SQL Server Data Tools (SSDT). Try this link: You can install SQL Server Data Tools (SSDT) without installing SQL Server by itself, and then you can use integration services. Try this link: https://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-2017