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()

I would like to help...please post the DDL for your tables and some DML to create some sample data. Have a look at this article if you have doubts about...

The code does not even compile. It is missing a SELECT in the CATCH block to deliver the error details.

I think the poster was trying to point out that the...

Without seeing your file and all properties of your flat-file connection object it's hard to say, but I'll take a shot at it providing some background info:

SSIS does not support...

I would like to help but am having a tough time picturing what the XML looks like that models what you have on your side since I can't see your...