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...

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....

"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...

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...

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...

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...

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

 51         INSERT INTO...

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

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...