hi,

Anyone knows how to load a cobol file to sql server table?

I tried bulk insert, I got problem with the special char 3 small square + /
If I select the records I don't see any char after 3 sqare + /


thanks, 

Don't know the file structure, but if it's a some form of fixed-width or 
delimited file you can use SSIS, or you can use BULK INSERT/bcp with a 
format file.

"Mecn" <mecn@yahoo.com> wrote in message 
news:u9toxhEdKHA.4952@TK2MSFTNGP06.phx.gbl...
> hi,
>
> Anyone knows how to load a cobol file to sql server table?
>
> I tried bulk insert, I got problem with the special char 3 small square + 
> /
> If I select the records I don't see any char after 3 sqare + /
>
>
> thanks,
>