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