You are here:

DTS Parameters

When you define an Integration Process (IP) type in the Console, you can specify DTS Parameters to use when the IP runs. On the Process Type tab, the DTS Parameters text box enables you to enter up to 4000 characters.

Parameter

Description

Passes command line connection information to all chained jobs.

Runs the job.

/RS

Runs the job in silent mode. Any messages that might pause processing are suppressed.

/SD=<dbname>

Specifies the source database name, <dbname>.

When creating an IP, /SD=%Filename is only valid if the source is a dynamic XML file. From the command line, /SD can be used with any source data.

/SL=<library code>

Specifies the source access library, <library code>. Possible values:

1 = ODBC
5 = SQLServer

/SN=<Y/N>

Specifies the Source connection may include Unicode data. Possible values:

Y or T or 1 = The source may include Unicode data.
N or F or 0 = The source does not include Unicode data.

If /SN is set to Y, T, or 1, verify:

Your source connection supports Unicode.
Your source and target connections provide the same level of Unicode support. Inserting Unicode data into a non-Unicode target may produce unexpected results.

/SO=<other info>

Specifies other source connection parameters, <other info>.

/SP=<password>

Specifies the source password, <password>.

/SS=<servername>

Specifies <servername> is the source server name or data source name.

/SU=<username>

Specifies <username> is the source user name.

/TD=<dbname>

Specifies <dbname> is the target database name.

Only use the /TD switch for SQL connections.
For ODBC connections, use the /TS switch.

Queue IP Examples:

/TD=%MessageLabel

/TD=%ScribeLabel

/TL=<library code>

Specifies <library code> is the target access library:

1 — ODBC
5 — SQLServer

/TN=<Y/N>

Indicates if the target connection may include Unicode or not: Y or N .

<T/F> or <1/0> are also valid parameters.
If /SN is set to Y, T, 1, make sure the target connection is named TARGET and supports Unicode.

/TO=<other info>

Specifies <other info> can be other target connection parameters.

/TP=<password>

Specifies <password> as the target password.

/TS=<servername>

Specifies <servername> is the target server name or data source name.

Note:

Use the /TS switch for ODBC connections.
For SQL connections, use the /TD switch.

/TU=<username>

Specifies <username> as the target user name.

/Vmyvar=<my value>

Specifies "myvar" is the name of the prompted variable and <my value> is the value for the variable.

Notes:

Text variables — The variable value must always be enclosed by quotation marks ("). The number of quotation marks required is based on the variable name:
- Text variable contains no spaces — Use 3 sets of double quotation marks.
- Text variable contains spaces — Use 4 sets of quotation marks.
For example, if the Variable, PromptVar, has a value of "Modified value", use sets four quotation marks:
tworkbench "MyTest.dts" /TS=c:\program files (x86)\scribe\dtsfiles\mydts.dts /VPromptVar=""""Modified Value"""" /RS /C
However, if the value is "ModifiedValue", use three sets of quotation marks :
tworkbench "MyTest.dts" /TS=c:\program files (x86)\scribe\dtsfiles\mydts.dts /VPromptVar="""ModifiedValue""" /RS /C
File IPs — When adding DTS parameters for File IPs:
/Vmyvar=%Path
Time and Query IPs — When adding DTS parameters for Time and Query IPs:
/Vmyvar=%Time