Presents your 
SQL SERVER E-NEWSLETTER for June 12, 2003

<------------------------------------------->

EXECUTE DTS PACKAGES WITH DTSRUN FOR MORE CONTROL

Data Transformation Services (DTS) import and export data between
different data sources such as OLE DB and ODBC. Used frequently within data
warehousing or data marts, these services can be: built once; stored in the
SQL Server msdb database, a COM-structured storage file, or as a SQL
Server Meta Data Service; and run multiple times as needed or at scheduled
intervals.

DTSRrun is a utility that executes packages created using DTS. You can
run your DTS package as-is by typing dtsrunui at the command prompt to
start the DTS Run utility. Or, if you want to run your DTS package with
minor changes, DTSRrun allows you to tweak performance by manually setting a
number of switches, including server name/instance name, user_name,
password, and package_name.

If you use an incorrect command line switch, create a syntax error, or
don't specify any switches, DTSRun will return an error. Spaces between
command line switches and values are optional, and embedded spaces may be
set between double quotation marks.

A/ global_variable_name:typeid=value is one switch/argument that has few
idiosyncrasies of its own. This switch specifies a global variable and
its data type. The entire string can be quoted, and it can be repeated 
to specify multiple global variables.

To set global variables using this switch with DTSRrun, you either need
Owner permission for the package or the package must have been saved
without DTS password protection enabled. If you don't have Owner permission,
you can still specify the global variable, but its values will be those
set in the package and not what you set in the /A switch.

EXAMPLES OF HOW TO EXECUTE DTSRUN

The following executes a DTS package saved as a COM-structured storage file:

dtsrun /Ffilename /Npackage_name /Mpackage_password

The following executes a DTS package saved in the SQL Server msdb database:

dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name/Mpackage_password

The following executes a DTS package saved in Meta Data Services:

dtsrun /Sserver_name /Uuser_nrame /Ppassword /Npackage_name/Mpackage_password /Rrepository_name

J.E. Harvey, MCSD, MCDBA, has been tinkering, writing, and consulting
about technology for more than two decades.

----------------------------------------