SQL Server - load cobol file to sql table

Asked By Mecn on 03-Dec-09 01:42 PM
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 do not see any char after 3 sqare + /


thanks,




Michael Coles replied to Mecn on 03-Dec-09 02:20 PM
Don't know the file structure, but if it is a some form of fixed-width or
delimited file you can use SSIS, or you can use BULK INSERT/bcp with a
format file.