CODEWITHSUNDEEP
sqlcsvssis
amarnadh
amarnadh

Reputation: 31

Data conversion failed while converting Time from CSV file

Csv Image

Problem:in mentioned Screenshoot data cannot able to convert into Time format column in SQL , this data is coming from csv file and executed by SSIS package only these column data from csv as string cannot loaded into database table

Error1:[OLE DB Destination [76]] Error: There was an error with OLE DB Destination.Inputs[OLE DB Destination Input].Columns[Recurring Start Time] on OLE DB Destination.Inputs[OLE DB Destination Input]. The column status returned was: "The value could not be converted because of a potential loss of data.".

Upvotes: 0

Views: 183

Answers (1)

hussein zakizadeh
hussein zakizadeh

Reputation: 173

Try replacing your SQL Server destination with an OLE DB destination. SQL Server destinations are type-specific and do not allow casts, implicit or not (as far as I know).

Upvotes: 1

Related Questions