Garadin,

Your scripts worked like magic. Again, appreciate your response. I have another issue with the same data set but I will figure it out or add a new post in...

Garadin,

Thank you so much for the script. I will try to run this code in this weekend or first thing on Monday morning at office. Really really appreciate your response!!!

Thanks.

Lynn,

Thanks for your reply but what's BIDS? Did you mean that I have to open the SSIS package using the SQL 2000 DTS designer and then run it through the...

Soonyu,

Thanks for your reply. I decided to take 70-431 right after my first post. 70-431 is easiest one to complete.

You can checkout the following link for XML in SQL2K5

http://www.developer.com/db/article.php/3531196

Also sqlservercentral got the following article on XML

http://www.sqlservercentral.com/columnists/lplatt/20010422115709_1.asp

Good luck!

john,

Only DTS packages that converted from SQL 2000 can be found in the Legacy --> Data Transformation Services area. Can't find the one I just created using SQL 2005 Import wizard. However, I can...

Rodney and Jeff,

Thank you so much for your inputs. This is really helpfull. I appreciate your responses.

by the way, congrate Rodney on your status from "newbee" to author..

Rodney,

thank you so much for your reply. I will try using the "patindex" in my code.

I really appreciate your reply.

Syed