4

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.

Hadi
  • 36,233
  • 13
  • 65
  • 124
BIDeveloper
  • 767
  • 3
  • 14
  • 28

2 Answers2

6

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

Hadi
  • 36,233
  • 13
  • 65
  • 124
  • 1
    Thanks Hadi for the comment. I figure out I need Integration services. I tried running the the package using batch file and it gives me an error of system variable not found and I am using system variable in my code. Though I found some "dtexec" in server. I dont know how it come there but that is not sufficient to run the packages. – BIDeveloper Dec 01 '17 at 06:14
  • Make sure that the name of system variable you used is typed correctly. It is case sensitive https://learn.microsoft.com/en-us/sql/integration-services/system-variables – Hadi Dec 01 '17 at 06:49
  • 1
    It is working fine in SSDT and on the machine where the Integration services are installed. Tried using the batch file and cmd both. – BIDeveloper Dec 01 '17 at 11:52
0

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

user12861
  • 2,358
  • 4
  • 23
  • 41