Run SSIS Package Without SQL Server Integration Services

sql-server ssis etl sql-server-2016 ssis-2016
Piyush Jain picture Piyush Jain · Nov 30, 2017 · Viewed 14.1k times · Source

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

Hadi picture Hadi · Nov 30, 2017

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

Related questions

How do I fix 'Invalid character value for cast specification' on a date column in flat file?

I have a CSV file with a {LF} delimiting each row and a date column with the date format as "12/20/2010" (including quotation marks) My destination column is a SQL Server 2008 database table of type date (not datetime) In my Flat …

Read More
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column

I am using SQL Server 2008 import and export wizard. I need to import a database. I opened the SQL server import/export wizard and I went through the following actions:- for the destination I chose "SQL server native client 10". …

Read More
SSIS - the value cannot be converted because of a potential loss of data

I am relatively new to SSIS. I am trying to extract information from an Oracle database using Microsoft OLEDB for Oracle and I am using this query: SELECT ID FROM Test I get an error message saying: the value cannot …

Read More