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

If there is no DTSSource column to put your GV into, DTS does not know where to put it - which may be stating the bleedin' obvious.  That is why...

Jeff, I do not envy you that problem!

Does your solution have to remain entirely within SQL Server?  Might the client accept a DLL which you can call as an extended...

From the error message, this does not look like a problem with your GV.  You could check this by replacing the field4 line with

msgbox DTSGlobalVariables("g_RunNr").Value

and then run the step...

Actually, I should have left this thread well alone

But the original post contains two questions - that is how I came up with my...

Hi Mike

I think that your answer should start with 'No' rather than 'Yes'

--edit-- I think you were answering question 2 - I was...