[an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] [an error occurred while processing this directive] 24x7 Script Archive


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