CODEWITHSUNDEEP
sql-servercsvt-sqlssis
amokMSBI
amokMSBI

Reputation: 11

Load table on SSIS with CSV files

I want to load a table from a CSV file, I have a varchar field type on the CSV but on my target table it is integer.

I want to load with SSIS.

How should I proceed?

Upvotes: 0

Views: 333

Answers (2)

mxix
mxix

Reputation: 3659

Use a Data Conversion Transformation on your Dataflow. And change your column from DT_STR to DT_I4.

Upvotes: 1

Filburt
Filburt

Reputation: 18061

Simply specify the column of your CSV source to be DT_I4 on the Advanced tab of your source.

You may want to add an error output for invalid data where this columns contains values that cannot be converted.

Upvotes: 1

Related Questions