Hi there I am doin BCP using SQLDMO. It imports rows but gives problem for Numeric, Date, Integer fields. Doest improper data gives some junk data. Whereas for Character fields data is imported properly.
Here is my .fmt file 8.0 3 1 SQLCHAR 0 0 "\t" 0 SecurityCode SQL_Latin1_General_Cp437_BIN 2 SQLCHAR 0 60 "\t" 4 pe_oid_accretion_desc SQL_Latin1_General_Cp437_BIN 3 SQLNUMERIC 0 9 "\t" 5 pe_oid_accretion_amt SQL_Latin1_General_Cp437_BIN
