SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Integration Services (SSIS), DTEXEC Rss

   Items 1 to 2 of 2   

How to execute an SSIS package from the command line or a batch file

An SSIS package that is executed on an ad hoc basis can be run from Business Intelligence Development Studio easily enough, but a package that is going to be run on a regular schedule is best executed through a batch file using the DTExec.exe command line utility.  Read more...
By Stan Kulp 2016/03/14 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 3,476 reads

How to Specify Command Line Parameters for DTEXEC Using Command Files

Everything I've read about the built-in configuration options is that you can retrieve values from a SQL Server table, an XML file, etc. but I really prefer to just use the command line options. I'm currently specifying 10 or more command line options on average. Do you have any ideas on a better way to do this?   Read more...
Rating:  Rate this |   Briefcase | 3,114 reads
   Items 1 to 2 of 2