Post reply

Decipher batch file which runs DTS packages

  • May 12, 2010 at 8:08 pm

    #222499

    Hi all,

    I'm trying to decipher each line of this batch file which I believe runs some DTS packages. Haven't looked at DOS in over 10 years. I put what I believe it does under each line. Can someone tell me if I am right or wrong with this?

    The DOS line is in bold.

    NET USE I: \\cobra_srv\cobra /user:auser cbi

    Maps directory to I drive using username auser and password cbi

    rem DTSRun /S "(local)" /N "Travis Set Co_Id" /G "{E51CA29E-2C40-4DA2-9892-A768D156E561}" /W "0" /E

    Runs DTS package Travis Set Co_Id on local server.

    Not sure what /G "{E51CA29E-2C40-4DA2-9892-A768D156E561}" /W "0" /E does (anyone know?)

    DTSRun /S "(local)" /N "Travis2SqlA" /G "{C5393827-52D4-4463-A11E-7FBC5F4D42FF}" /W "0" /E

    Runs DTS package Travis2SqlA on local server.

    Not sure what /G "{C5393827-52D4-4463-A11E-7FBC5F4D42FF}" /W "0" /E does (anyone know?)

    DTSRun /S "(local)" /N "Travis2SqlALog" /G "{ED097657-BCB4-46B3-9EDC-7FBD9E10E257}" /W "0" /E

    Runs DTS package Travis2SqlALog on local server.

    Not sure what /G "{C5393827-52D4-4463-A11E-7FBC5F4D42FF}" /W "0" /E does (anyone know?)

    DTSRun /S "(local)" /N "Travis2SqlAAudit" /G "{5C92279C-491E-4BFD-8DF8-FDAABC80E4C5}" /W "0" /E

    rem DTSRun /S "(local)" /N "_Desktop_CSV_Export_Active_Clients" /G "{6E1890B5-6F3B-4F9D-97B6-C3FE02C4CE61}" /W "0" /E

    Runs DTS package Travis2SqlAAudit on local server.

    Not sure what /N "_Desktop_CSV_Export_Active_Clients" /G "{6E1890B5-6F3B-4F9D-97B6-C3FE02C4CE61}" /W "0" /E does (anyone know?)

    DTSRun /S "(local)" /N "_Desktop_CSV_Export_Active_ClientsTableDriven" /G "{3589863F-1C15-43A2-AE34-C7E9F64D6D6D}" /W "0" /E

    Not sure what /G "{3589863F-1C15-43A2-AE34-C7E9F64D6D6D}" /W "0" /E does (anyone know?)

    call c:\temp\active\zipcommand.bat

    Runs another batch file called zipcommand.bat

    NET USE I: /DELETE

    Delete mapped drive I

    CALL travis2mequon.bat

    Runs another batch file called travis2mequon.bat

    call travis2csv

    Doesn't have a .bat extension, but I believe this may be running another batch file.

    Thanks,

    Strick

  • May 14, 2010 at 10:49 am

    #1167668

    RE: The DTSRUN arguments.

    /G and what follows it is the package ID. Each package has a unique GUID as it's package ID.

    /W "0" specifies that the package completion status will not be written to the Windows Application Log.

    /E specifies a trusted connection to the server.

    Greg

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply