hello, I have tried to create your 'test' table it works!!.

when edit DTS you need to close your spreadsheet otherwise you get weird error.

you can rewrite as:

--assume that country_id and client_id are not text/image type.

select a.* from TABLE1 a

where not exists (select 1 from TABLE2 b

    where b.country_id = 61

      and b.client_id = a.client_id)

and a.country_id =61

That's weird!!

The only thing that I can think of is data may still sit in cache when you re run the proc will run in  seconds.

DAB, have you tried expanding the cell in csv file to 6 decimal places?

Manop,

The problem lies here 'Microsoft OLE DB Provider for SQL Server Copy' . It is not a recognised provider.

can you connection source to 'Microsoft OLE DB Provider for SQL...

Will, how about schedude your task on the server???

I wondering if you can give a sql sample where you can capture an error??

I still believe that it will never print your error message.

I just want to let everybody know that errorhandlings in sql server 2000 do not work!!!.

Eg.

   UPDATE permanent_tbl2

   SET    ...

   FROM   #temp ....

   SELECT @err = @@error

IF @err...

select * from @fnTableFunction -- I don't think this is a function? more like a table variable.

have you considered using osql or isql commands??

Basically write your query (what/how you want it to output) to a file.

something like this (not sure syntax is correct!):

isql -Sserver_name -Ddbname...

Not sure if this will help....

why don't you remove "ORDER BY tDocArchive.doa_batchorder" from the original query?

Austin, Looking at the given query below this won't work. You will get error like invalid object name on legalhotline.call

/*

select member.member_number, member.last_name, legalhotline.call.member_number, legalhotline.calldate

from member, legalhotline.call

where member.member_number=legalhotline.dbo.call.member_number

*/

assuming your 2 databases...

Cory, the examples above assume that you have already linked the servers.

If your databases sit on different servers and are SQL server one way you can do:

- in EM go...

If both servers are SQL use linked server??

In DTS package,

create a database connection and a Excel connection

create data pump between 2 connections.

put your query in the source tab.

I hope this what you after...