question

sqlthirst avatar image
sqlthirst asked

Datatype Error in Import -export wizard

Hello i have a column in table which has data type **datetime2**, which is expected to hold data like (**12/15/2015 12:12:00 PM**). but when i am importing data from flat file and configure the property of the column to database time with precision i got the below error There was an error with input column "DTFETCH" (196) on input "Destination Input" (131). The column status returned was: "Conversion failed because the data value overflowed the specified type.". (SQL Server Import and Export Wizard) kindly help me to fix this error Thanks
sql-server-2008ssisdts
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.