|
I know this doesn't answer your question, but have
you considered doing it with DTS instead of BCP?
I used it recently to migrate an Access database to
PostGreSQL and it worked great. One of the big advantages is the ability to
transform the data as it is being converted.
It is also built in to MSSQL Server. I have used it
numerous times for data transformations within SQL Server and have always
enjoyed working with it.
Iam trying to
import data from ms-sql server to postgres. I export the data which has
datetime columns in sql server using BCP. I use the following to import back
into postgres.
copy tablename
from 'c:\\bcpdata\\mcfa\\tablename.txt' with delimiter as '\t'
I get the
following error !!
invalid input
syntax for type timestamp: ""
My input file has
the timestamp value like
2004-09-30
11:31:00.000
Any clues
???
Thanks !
Goutam
Confidentiality
Notice
The information contained in this e-mail is confidential and
intended for use only by the person(s) or organization listed in the address.
If you have received this communication in error, please contact the sender at
O'Neil & Associates, Inc., immediately. Any copying, dissemination, or
distribution of this communication, other than by the intended recipient, is
strictly prohibited.
|
