Thanks for your help

When I set the SET ANSI_WARNINGS and SET ARITHABORT settings to OFF, it happens what you say.

What is strange is that the 2 database have the same values for 'arithabort'...

Thanks for your help !

My code was wrong : I have declared my variable @file as varchar and not as sysname.

In fact, it happens when the length of my variable @file is more than 18 characters (for example : 'C:\log_00000015.txt').If it's less ('C:\log_0000001.txt'). , no problem. Strange...

My file doesn't contain...

Maybe i'm wrong but what happens if you modify your query (INSERT INTO TESTING.DB2DSNY.MSQL.TEST_TABLE Values ('ABCDEFGH'))  and use the instruction OPENQUERY... ?

Thanks a lot for the replies ! There is what I needed.

For my last project, I have used only linked server and T-SQL to program my imports for each day.

So...

ok thank you, i was looking for something more complicated

In my case it's :

SELECT

...

FROM

tblName

WHERE

Col1 = Col1 AND

Col2 = Col2 AND

Col3 = Col3 AND

Col4...