Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Execute DTS Package on SQL 2008R2 › Re: Execute DTS Package on SQL 2008R2
April 8, 2013 at 4:54 PM
#26034
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