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...

Hi David - looks like you've cracked it.

I would suggest adding a WHERE clause too:

UPDATE    Subset

SET              Subset.Leadengineer = Contact2.ULEADENGIN

FROM         heat2.Subset Subset INNER JOIN

                      Goldmine.dbo.Contact2 Contact2 ON Contact2.Accountno = Subset.SupportInfo

WHERE Subset.Leadengineer <>...

Kenneth is correct about FLOATs.  But if EDEB is DECIMAL, the following WHERE clause should select only those with >2 d.p.'s.

where year(data)=2003 and round(edeb, 2) <> edeb

Why not just write a stored procedure and use that?  Usually no need to use DTS if all of your data is within SQL Server.

-- edit.  I misread your original...