[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::Setting Validate_Password componet for MySQL Database to ensure password policy settings
Inadequate Password Settings for MySQL Database We observed that the `validate_password%` settings on hostname `<insert hostname>` a...
-
When i trying to load data from MS access (MDB) to SQL ,i am getting the below error. Error: 0xC0209303 at Package, Connection mana...
-
Seamless Data Archiving: Exporting, Importing, and Pruning MySQL Tables Introduction: In the dynamic landscape of database management...
-
An error occurred while starting mirroring. Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo) The remote copy of dat...
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