Information générale
Forum:
Microsoft SQL Server
Titre:
BCP Errors when importing using Format File and RAW Data
I am having a problem importing data from a RAW datafeed my company receives on a daily basis.
There is a Format file for the RAW file and from the best I can tell, the correct DDL for the table that the file is imported to.
I am in the process of migrating this BCP along with about 80 other ones to Stored Procedures and Batch files.
As of right now, all but one seems to be working ok.
I keep getting the error "Line 1: error near (1001)" when the BCP import takes place.
I have look at the input file and the format file, as well as the Table. I cannot find the problem.
If someone could assist with this, I will be more than happy to e-mail them the files to take a look at (i.e. FMT, DDL, RAW files).
Thanks in advance.
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement