Forum Replies Created

Viewing 9 posts - 16 through 24 (of 24 total)

  • RE: SSIS Is Not Just for SQL Server

    Hi, sorry for the confusion; I'm a newbie to SSIS, but a veteran of SQL Server. I'm not sure what you're asking for. I think you're asking to see...

  • RE: SSIS Is Not Just for SQL Server

    I'm pulling my hair out over this. I'm trying to pass the value of a package variable to a batch command script running in a SSIS Execute Process Task....

  • RE: Performance issue with XML

    "My bigger concern, and the main reason for the changeover, was the resource leaks with sp_xml_preparedocument if you didn't make the corresponding call to sp_xml_removedocument (we had a dev that...

  • RE: Performance issue with XML

    I'm in the middle of a similar conversion, from OPENXML to xquery, and have similar questions.  When you do a showplan on these, there appears to be lots and lots...

  • RE: Advanced XML Processing

    Very concise article.  I spent a couple days figuring this out.  Why is there nothing in BOL as simple as this? 

    You might note that to assign the results of...

  • RE: Sales Order Workshop Part IV

    Not sure WHY this works, but it works.  I changed the Path in the FROM clause to include the /ID node, and then use .value method to get the value...

  • RE: Sales Order Workshop Part IV

    Enjoyed the series. Found I had to make this change in the header insert.  Otherwise I get a datetime conversion error. 

     51         INSERT INTO...

  • RE: An Introduction to the Service Broker

    I finally got this to work.  How do I get rid of messages in sys.transmission_queue? 

  • RE: Moving

    Good luck Steve.  When I moved into my house last June, I discovered that my street address was wrong.  The Street Address, not just the zip code.  The house is...

Viewing 9 posts - 16 through 24 (of 24 total)