but you write:

 "C:\BCPTEST\TESTBCP.TXT and executed the command. Still the same error".

I am using BCP and BULK INSERT and some time i get the same error in case of bad path...

Check if the path is correct and  is included into:

"c:\path"

Yes,

thank a lot

I thought the same thing and is working

Just to explain better...

the statement

SET @SqlCheckIdentity = 'SET IDENTITY_INSERT ' + @TablesName + ' ON'

is put before the ISERT statement and after

I' llwrite

 SET @SqlCheckIdentity = 'SET IDENTITY_INSERT ' + @TablesName...

I tried using identity as arguments and everithing works fine

Thank

Hi guys ...

there is anything to write as code...it is only a BULK insert statement....

BULK INSERT DBa.dbo.Ta FROM 'file.dat' with (arguments)....

and anything else....

Your suggestion about KEEPIDENTITY may be interesting....

I'll...

Thank very much.......

but I need this in production to make update from a file created with bcp from another database....

Very bad in production in your opinion....?

thank......

Dont't worry be happy....

I'll make an example.....but sometimes I am not in front of PC......to cooperate....

Cooperation is the best way to solve problems.....

I have just tried set: SET IDENTITY_INSERT Table ON/have to delete OFF, but it doesn't work anyway.

I have found out that in INSERT and UPDATE statement I  have to delete code...

I have partially solved my problem..

If I convert to varchar the query works.

The problem is that in the case of UPDATE statement, like:

UPDATE tablename SET CAST(field1 as varchar (100)) = CAST(TempT.field1 as...

I think using a table and assign a sequence with a ordering value (1.0, 2.0,3.0.....n.0, 1.1,4.3....) it should be the right solution.

Thank to everybody for your suggestions.....

I 'll follow your instruction to reach my goal......

(I thought another way.....to build an easy worksheet and then...

OK.....may be

but if I have a table with all data inserted and then add a new value and I want to have the new data (eg apple) after peras...

Sorry,

reading back I wrote very bad....

I mean...I don't want to keep fruit col in alphabetic order, I insert data:

id       fruits

1        bananas

2         peras

3         peaches

..........................

n        fruit

Then I would like to insert a new...

.....Back again......

thank to everybody,

I always used cursor, but recently I have realized to use While loop cicle just to see the difference and performance ....

Of course the use of...