Scheduler Usage

Hi,

Is there a way to run dts packages and other jobs within the MS SQL framework via Control M 6.2.01 for distributed systems? Here's an example of the script I am trying to setup to run via Control M.

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

Travo

Hi,

You can directly run Control-M command or run as a batch file with all the required parameters..

dtsrun /S SQLServer,49169 /E /N Table /A\
gsDatabase:8="SQLSever_instance,49169" /A gsCatalogue:8=\
" " /A gsIntegratedSecurity:8="SSPI" /A gsRootDirectory:8="D:\" \
/A giDurRetainLogFiles:3=7 /A giDurRetainProcZipFiles:3=7 /W True

1. Control-M Owner account should have the permission to connect SQL Server.

Hope this helps...