Execute DTS Package on SQL 2008R2

Home Page Forums BizTalk 2004 – BizTalk 2010 Execute DTS Package on SQL 2008R2

Viewing 1 reply thread
  • Author
    Posts
    • #26011

      Execute DTS Package on SQL 2008R2

      how to execute a dts package on sql 2008 R2 from BizTalk 2010?

      All help is greatly appreciated.

       

      Thank you

       

      AJ

    • #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

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.