DTS Package

Some examples running with Control-M and Control-EM database.
Post Reply
TRAVO

DTS Package

Post by TRAVO » 04 Jun 2007 5:20

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

User avatar
Zakeer
Nouveau
Nouveau
Posts: 43
Joined: 26 Feb 2007 12:00

Post by Zakeer » 05 Jun 2007 9:29

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

Post Reply