Execute DTS Package on SQL 2008R2

That is correct, xp_cmdShell is not allowed for security reasons

The option to call a sql job is not good in my case because I am also looking to get a response back from sql.

So, Yes I did go with the option of calling a stored procedure from C# within my orchestration. That works fine as well.

Thank you

Ajay