[OLE DB Destination [9]] Error: There was an error with input
column
|
SYSTEM_DATE_TIME (130) on input "OLE DB Destination
Input" (22). The column status returned was: "The
|
Value could not be converted because of a potential loss of
data."
|
Resolution:
|
Check any invalid date value in source csv file, if yes then,
change it to 01\01\1753.(Or try to change the
Invalid date value to
valid date value).
That’s all.
|
Backup my known things and restoring it into DBA Learners.......
Wednesday, October 10, 2012
[OLE DB Destination] Error in SSIS:
Subscribe to:
Post Comments (Atom)
MYSQL:::Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables
Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...
-
Post scripts to implement after successful SQl Server installation in a new server: 1. Listing the advanced configuration options and ...
-
An error occurred while starting mirroring. Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo) The remote copy of dat...
-
When i trying to load data from MS access (MDB) to SQL ,i am getting the below error. Error: 0xC0209303 at Package, Connection mana...
Thank you so much for looking up to provide the best of SSIS and other related utilities in order to save the right set of resources.
ReplyDeleteSSIS Postgresql Write