Hi again, I have asked around but I cant find anyone who understands where your bits of code go into the SP I created below......

CREATE procedure usp_ImportMultipleFiles @filepath varchar(500), 'Changes'

 @pattern...

Thanks for that.

I think Ill have to get some extra help in as to how to use what you have just told me in the stored procedure. Its all a...

Okay. Here is the SP that gets the files....

CREATE procedure usp_ImportMultipleFiles @filepath varchar(500), 'Changes'

 @pattern varchar(100), @TableName varchar(128)

as

set quoted_identifier off

declare @query varchar(1000)

declare @max1 int

declare @count1 int

Declare @filename varchar(100)

set @count1 =0

create table...

Thanks for that,

I think Im going to put a few of these suggestions into the people that create the files as it seems to be the way forward on this...

Thanks for that,

Im at this very moment trying to get my head round using file formats. Ill keep going with that!

Debbie

Unfortunately not. We get the files in as is and we are trying to sort out the import so we dont have to touch any of the source files.

The quoted...

Thanks for that.

Ill try that. I havent used the BCP utility so Im not sure how that file fits in though. Im running the format file from a stored procedure.

Ill let...

Hi again,

I have made sure the second line says 41 and the 38th row has   "\r\n"  against it as this is the last record in the source file. Still getting the...

Thanks for the reply,

Im struggling to understand what you mean with 'Fill column1 with all you find'

Im editing the fmt file in textpad. Ive edited the last line to

41 SQLCHAR 0 0 "\r\n" 0 ImportDate Latin1_General_CI_AS

but...