Jeff,

FInally it works!!!!!!!!!!!!

Thanks so much,have removed the character encoding,and changed the rowdelimiter........it actually imported 98 of 144 files and I think the rest requires some data clean up.

Be blessed!

Error I get is the following

(2 row(s) affected)

(2 row(s) affected)

Msg 4864, Level 16, State 1, Line 1

Bulk load data conversion error (type mismatch or invalid character for the specified codepage)...

Hey Jeff,

I have been trying it the whole night yesterday and all the day today.. and it didn't work out.. (it goes well till some point and then generates...

Hey Jeff and all

He didnt actually gave me the batch code for that,

but I found out the following which is close to my case(our case at this point:-))

someone suggested to use batch programming on the files to insert storeid.

Jeff thank you

thanks guys

Unfortunatley our company uses DB2 as main database ,

but they have sql server on side which is version 2000.

I ask apology for posting it here,but that was the only option...

Thanks for responding

please see sample of data given and the result required:

CREATE TABLE [dbo].[OrdersBulk](

[CustomerID] [int] NULL,

[CustomerName] [varchar](32) NULL,

[OrderID] [int] NULL,

[OrderDate] [smalldatetime] NULL

[storeID]...