Convert SSIS data from varchar to int

Question

Convert SSIS data from varchar to int

Asked 7 years, 3 months ago

Viewed 591 times

0

I’m locked into a conversion by SSIS, scenario:

I have a CSV file, which I need to import into a table already created in the database, In this table of the database I have a column already populated that receives data type INT, I noticed that there are records with up to 9 characters in this column.

I am trying to convert the data of this CSV from varchar to integer, however, in the data type options provided by SSIS have at most Eight-byte, which is returning me the error

[Data Conversion [55]] Error: Data conversion failed while converting column "CONTA" (10) to column "Copy of CONTA" (72).
The conversion returned status value 2 and status text "The value could not be converted because of a potential loss of data."”.

Can someone help me or give me an alternative?

Already tried to import everything as varchar for a table (temporary) and then use this table to select/Insert in your target table?

– Marco Souza

2017/03/08 at 13:36

1 answer

Browser other questions tagged sql sql-server integration ssis

You are not signed in. Login or sign up in order to post.

by Andrey Hartung • **1,763** points · Answer 1 · 2017-04-04T18:03:01+00:00

Right click on the task that fetches the CSV data and opens the Advanced Editor, then you go to the Input and Output Properties > Source > Output Columns > click on the field you want to change type > In the Datatype option you change from whatever is to NUMERIC[DT_NUMERIC]