Not 100% sure that I have understood the question - I am no XML dude - but if you are having problems as a result of SQL Server generating primary...

Can you be a little more specific - is the import actually failing, or are you validating the data after import and finding that it is 'corrupt' because it fails...

DTSSource and DTSDestination are available within a Transform Data task.

When you create a Transform Data Task, you must specify a source connection and a destination connection.  It is from these...

TDS_RET_STATUS returns zero matches on Google.  Are you sure that you've typed it in correctly?

... so how much space do you have on your hard disk?

My mistake - I read the post too quickly

It may be stating the obvious, but it sounds like you've run out of disk space.  How big was the database (MDF + LDF) before it was backed up and...

Here's an example from Northwind that gives the same error:

declare @id int

select @id=categoryid, description from categories where categoryid = 1

The error message is actually quite helpful - you cannot mix variable...

Hi Ann, I would do this slightly differently.

Create a new SQL Server table - 'import', or whatever - and import all of your Excel data into that.

Then have your DTS...

Not 100% sure what that error message means - sounds like a security problem - perhaps the server doesn't have the right privileges to write to your PC.  Are you...

Nice one David!

Hi - this is not straightforward, so I'm not surprised you are having trouble.

Would it be sufficient to perform the following checks:

1) That the length of the string is 20...

What's a 'vatch'?

You're trying to export all data and all objects?  Why not just backup/restore?

Hi Vladan - it's OK, I think Jeff's having a bad day.  I am native English and his comments were a little bit harsh - but I think we understand...