Problem when import csv
- phong.dangdinh
- Topic Author
- Offline
- User
-
Less
More
- Posts: 5
- Thank you received: 0
3 days 10 hours ago #14710
by phong.dangdinh
Problem when import csv was created by phong.dangdinh
Hi there,
I use SSIS to import CSV files to Postgres. I got an error: "Validation error. Data Flow Task: Data Flow Task: The OLE DB provider failed during the data type conversion verification for "redemption_time"."
I used Data Conversion and tried with some other data types, but it is not helpful.
Please help to fix this.
Many thanks,
Phong
I use SSIS to import CSV files to Postgres. I got an error: "Validation error. Data Flow Task: Data Flow Task: The OLE DB provider failed during the data type conversion verification for "redemption_time"."
I used Data Conversion and tried with some other data types, but it is not helpful.
Please help to fix this.
Many thanks,
Phong
Attachments:
Please Log in or Create an account to join the conversation.
- phong.dangdinh
- Topic Author
- Offline
- User
-
Less
More
- Posts: 5
- Thank you received: 0
3 days 9 hours ago #14711
by phong.dangdinh
Replied by phong.dangdinh on topic Problem when import csv
Please try with the attached file.
Please Log in or Create an account to join the conversation.
- phong.dangdinh
- Topic Author
- Offline
- User
-
Less
More
- Posts: 5
- Thank you received: 0
3 days 9 hours ago #14712
by phong.dangdinh
Replied by phong.dangdinh on topic Problem when import csv
Attachments:
Please Log in or Create an account to join the conversation.
- phong.dangdinh
- Topic Author
- Offline
- User
-
Less
More
- Posts: 5
- Thank you received: 0
2 days 9 hours ago #14714
by phong.dangdinh
Replied by phong.dangdinh on topic Problem when import csv
Any update, please!!!
Please Log in or Create an account to join the conversation.
Time to create page: 0.283 seconds
- You are here:
-
Home
-
Forum
-
Main PGNP Forum
-
SQL Server/DTS/SSIS/Linked servers/Replication
- Problem when import csv