Post reply

SSIS, Execute SQL Task and XML recordset

  • June 7, 2006 at 7:02 am

    #117925

    I have an SP that generates valid well formed XML. When I try to put the results of the SP into a string or object variable using the Execute SQl Task, I always get an error unless the size of the XML is 496 characters or less.

    Any ideas why?

    Barry Memberg

    Sr. DBA

    Apptis, Inc.

    membergbj@state.gov

  • June 7, 2006 at 11:28 am

    #642354

    Barry,

    We are encountering the same problem with SQL 2005 SSIS SP-1. The packages worked fine before we installed SP-1. My work-around was to move the packages that contain 4XML execute SQL tasks off our SP-1 box and onto a SP-0 box (with Integration Services installed.)

    The solution to this is probably going to be a hot fix and one of us will need to initiate support with Microsoft, as this is appears to be a SP-1 bug.

  • June 7, 2006 at 12:24 pm

    #642368

    Thanks for the reply. I moved the package to a Server with no SP and it worked.

  • June 8, 2006 at 1:36 pm

    #642653

    I've initiated support with Microsoft about this, but the more people that complain, the quicker they'll fix it.

  • June 8, 2006 at 2:07 pm

    #642662

    I also contacted a Microsoft evangelist and he will forward the problem to the proper support team for action.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply