stoolpigeon
Programmer
I am trying to copy a delimited text file into a table using the Copy command.
The problem is that the copy fails every time the process hits a date field that is empty. I get the error:
copy: line 154, Bad date external representation '' lost synchronization with server, resetting connection
I have a default value for all of my date fields. I could go into the file and add dates but it has over 900,000 records and I'd rather not.
Is there a way around this, or am I going to need to use some other method to import the data into the tabel?
thanks,
Ron
The problem is that the copy fails every time the process hits a date field that is empty. I get the error:
copy: line 154, Bad date external representation '' lost synchronization with server, resetting connection
I have a default value for all of my date fields. I could go into the file and add dates but it has over 900,000 records and I'd rather not.
Is there a way around this, or am I going to need to use some other method to import the data into the tabel?
thanks,
Ron