Post reply

DTS

  • June 26, 2009 at 2:32 am

    #205861

    i created a DTS to export data from databse to excel.i configured a job to run this dts . But i need to specify the DTS name in the STEPS(command) of the job. It is just showing a long GUID ,but not DTS name.

    CAn any advise the syntax for DTS run.

  • June 26, 2009 at 2:51 am

    #1015848

    The GUID is the package identifier. You can use the /G option with DTSRun to execute the package using the GUID. The syntax for DTSRun is:

    DTSRun

    [/?] |

    [

    [

    /[~]S server_name[\instance_name]

    { {/[~]U user_name [/[~]P password]} | /E }

    ]

    {

    {/[~]N package_name }

    | {/[~]G package_guid_string}

    | {/[~]V package_version_guid_string}

    }

    [/[~]M package_password]

    [/[~]F filename]

    [/[~]R repository_database_name]

    [/A global_variable_name:typeid=value]

    [/L log_file_name]

    [/W NT_event_log_completion_status]

    [/Z] [/!X] [/!D] [/!Y] [/!C]

    ]

    Example: DTSRun /S "MyServer" /N "MyPackage" /W "0" /E

    The above example would execute a package called MyPackage on the server MyServer using a trusted connection without logging the completion status to the Windows Application Log.

    Further details are available in Books Online (BOL).

  • June 26, 2009 at 3:52 am

    #1015870

    Thank you very much

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

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