That worked. Thanks!

Thank you both! It works beautifully!

Thanks!....that worked beautifully...but now when I try to run the following SQL, I get nothing. I know I suck at this XML parsing, so I appreciate the help

;WITH XMLNAMESPACES ('http://www.xyz.com'...

That is perfect. Thank you!

Thank you both....they work beautifully!

Thanks for the information....lets see if this helps

IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL

DROP TABLE #mytable

CREATE TABLE #mytable(

[Product] [varchar](1) NULL,

[TransactionYYYYMM1] [varchar](6) NULL

) ON...

I have tried that, I didn't have a whole lot of success...but odds are, I am doing it incorrectly.

Sorry for the delay, but that did exactly what I needed. Thanks for the help!

Thanks...I probably should have been more clear. the XML is a column in a table and I need to write this is a way it will work in a select...

I changed it to

Data Source=xxxxxxxxx;Initial Catalog=IMS;Provider=SQLNCLI10;Integrated Security=SSPI;Auto Translate=False;

and still get the following error

Error: 2011-01-06 10:23:15.52

Code: 0xC0202009

Source: metavanteach Connection manager "IMS"

Description: SSIS...

Data Source=xxxxxxxx;Initial Catalog=IMS;Provider=SQLNCLI.1;Integrated Security=SSPI;Auto Translate=False;

OF COURSE!!!! Sorry, I had a huge brain fart! Thanks!

I agree 150% that there is a better way to store and manage these packages....but I am inheriting an existing setup in which is would be VERY difficult to go...

Bob Hovious (2/9/2010)

---

As a side note, when I was learning Service Broker a couple of years ago, I read over thirty articles, tutorials and walkthroughs, including many from Microsoft....

Thanks...I tried that and got

"The report parameter 'ObjectName' has a DefaultValue or ValidValue that depends on Report paramter 'ReportParameter1'. Forward dependencies are not valid"

I apologize, but this is my first...