Thanks for your response, but some times we skip week ends. when we skip week ends the total will be wrong.

Thanks.

I did find the problem but don't the solution. The problem is ID in both tables is 20 CHARS but we store 9 or 10 CHARS.

In both tables ID's are...

Thanks, Trigger worked for me.

Thank you very much.

Thanks, It worked.

Yes, I am specifying the full path, but there is no Drive letter on server B that I am specifying.

David,

Thanks for quick response.

When i test it,i see all rows but when run the job inserting just one.

Hi,

I am using DTS and working with no errors but inserting just first row, any ideas please, where i am doing wrong.

Thanks.

Thanks for your responses,

rdfozz,

Nice to do bcp or bulk insert because i want to do with in stored procedure.

ThomasH,

I tried your solution but got the following error message.

Server: Msg...

Hi,

The data length would be 4000, need find last occurance of (2)Total line,(3) Total line,(4) Total line (5) Total line (6) Total line (7) Total line.

I did in loop from...

ThomasH,

1. What is the Max(DataLength()) you would be dealing with?

8000

2. Is the data CR/LF delimited, or other delimiter?

not delimited, Stored in database as text field

3. Is there any...

Hi,

I have installed SQL SERVER and Sybase SQL any where client on same machine, did not face any problems.

Thanks.

Try This,

cnn1.Open ("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Password=PASSWORD;User ID=sa;Initial Catalog=Northwind;Data Source=MYSQLSERVER")

Hmm,not getting correct results.

I did not follow you, Could you please explain bit more.

Thanks