DTSRUN is said to allow values to be passed-in to the DTS package. Books
Online has no complete example of this being done so I have to rely on the
syntax alone. Fine, but . . .

The syntax for DTSRUN shows /A global_variable_name:typeid=value. but I
don't know what values "typeid" takes. There is not a single mention in
Books Online, MSDN, or the two DTS books I purchased. So, I would like to
know where I can find decent examples as well as an enumerated list of
"typeid" values. I can't believe this info is not included in BOL.

TypeID looks like this

Integer (small) 2
Integer 3
Real (4-byte) 4
Real (8-byte) 5
Currency 6
Date 7
String 8
Boolean 11
Decimal 14
Integer (1-byte) 16
Unsigned int (1-byte) 17
Unsigned int (2-byte) 18
Unsigned int (4-byte) 19
Integer (8-byte) 20
Unsigned int (8-byte) 21
Int 22
Unsigned int 23
HRESULT 25
Pointer 26
LPSTR 30
LPWSTR 31


From

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\coprompt.chm::/cp_dtsrun_95kp.htm

so /AMyVar:8="My String"



"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote

Allan,
Perfect! Where is this in Micirosoft Documentation?

Snake

"Allan Mitchell" wrote:

Books online at the URL I posted

Go | URL | Paste

"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote