Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag 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 | 2,468 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 | 2,899 reads
   Items 1 to 2 of 2   
 
Tags