Scheduling DTS package run

 

To run DTS packages use dtsrun command line utility which is installed on the SQL Server server and with MS Enterprise Manager. This utility includes a variety of command switches you can use for customizing the execution of a package.

Syntax

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]
]

For more info on dtsrun please see http://msdn.microsoft.com/library/en-us/coprompt/cp_dtsrun_95kp.asp