Viewing 9 posts - 16 through 24 (of 24 total)
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...
July 7, 2008 at 9:43 am
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....
July 3, 2008 at 5:48 pm
"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...
August 2, 2007 at 9:51 am
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...
August 2, 2007 at 9:13 am
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...
May 9, 2007 at 10:28 am
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...
April 11, 2007 at 1:09 pm
Enjoyed the series. Found I had to make this change in the header insert. Otherwise I get a datetime conversion error.
51 INSERT INTO...
April 5, 2007 at 5:02 pm
I finally got this to work. How do I get rid of messages in sys.transmission_queue?
August 23, 2006 at 11:11 am
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...
January 18, 2006 at 10:22 am
Viewing 9 posts - 16 through 24 (of 24 total)