Check out http://www.connectionstrings.com

I was a full-time C#/SQL dev 4 years ago (80/20 split) and I could not stand SSIS when it first hit the scene because it seemingly made things so much...

I made up some DML since you did not provide any :Whistling:

INSERT INTO dbo.root(root_id)VALUES (1)

INSERT INTO dbo.subroot(subroot_id, root_id)VALUES (1,1)

INSERT INTO dbo.tempxml(subroot_id, childnodes)VALUES (1,'<data value="test"/><data value="test2"/><otherdata value="test3"/>')

With your...

Thanks for playing along too...I thought this might be doable using the Pivot transformation however I have decided 'no'. If the elements were Child1, Child2, Child3, Car1, Car2, Car3, etc....

I like that idea. It would definitely reduce the number of forums and make sure people are in the right place. That's how things are organized on the mothership's forums...

Jason Selburg (3/18/2011)

---

Modify my previous script to use a temp table instead of a table variable, and it will work.

I think I've found a Question of the day to submit....

Something like this should get the job done quickly and dirtily as long as you have a decent enough sample size to hand to TABLESAMPLE. Be aware however that TABLESAMPLE...

I think I am close...but not quite there...could you adapt your initial schema doc to your example XML please so the names and elements match up? I think Child and...

No. They are different. A server can host one default instance and/or many named instances. A default instance has no instance name and can be accessed without providing a port...

Witch-hunt anyone? If you have backups of your msdb database you can restore those starting with your oldest backup in chronological order to a non-critical instance as a database with...

ejdonavan, I am assuming this is a SQL 2008 SSIS Package because I cannot open it in BIDS 2005. It'll need to wait until tonight before I can have a...

I wish I could say definitively...I just know that ADO.NET handles it and OLE DB [may] not. I say [may] because I haven't isolated any cases when you can use...

Seriously!?! Your asking for us to help you with a problem directly from a certification course you're taking?

If you have a specific question about SQL I would be happy to...

Sounds like its setup correctly but SSIS being mostly visual it's hard to say what the issue might be...can you zip it up and post the package as an attachment?

You can check the level of the current DB using this:

SELECT compatibility_level

FROM sys.databases

WHERE database_id = DB_ID()