Hi there

I seem to be having problems with my dtsrun script which I am running
from a scheduled job.

The others work fine, but this one has a few more parameters:

DTSRun /S"(local)" /U"dc" /P"dc" /N"ImportUsers"
/A"Filename":"8"="D:\DC\Temp\7a99a6a9-d6ff-4de9-b6d0-43adc6173733.csv"
/A"RandomGuid":"8"="e704d99f-3ee1-42ef-8aee-0df4ecd6b5d4"
/A"DeleteNonCSV":"8"="0" /A"OverWriteFields":"8"="30"

Would anyone be able to explain what the :"8" is in the script as I
have only ever just used it! The DeleteNonCSV and OverWriteFields and
integer values and are not being recognised?

Any help would be fantastic!

Thanks

Dave

:8 indicates that the value for the global parameter is a string. You might
want to change it to :3 (integer) for DeleteNonCSV and OverWriteFields.

You can find the complete list of codes for the datatypes under the Remarks
section in the DTSRun topic in Books Online.

--
Jacco Schalkwijk
SQL Server MVP


<bungle (AT) wizardbuy (DOT) com> wrote