I might have given wrong impression by mentioning word 'Script'.

In our job we have a .bat file which executes SQL queries using 'SQLCMD' command. so we dont have any script...

thats right. My concern is about how to execute the ssis remotely on server machine.

In my previous reply my question was, in the process of "generate a message and...

I guess thats like an asynchronous command i.e. it runs in background.

In my case i need to run the DTS/ssis and upon successful completion execute the next step n so...

I liked your first approach. It does work in my scenario.

But I found out that DBA team is not ready to give us rights to execute the SQL agent jobs.

I...

Thanks for the response!

Machine B is used for SQL server and machine A is used for CRM application(Siebel) and we execute scripts from machine A since we need to refer...