how can i transfer incoming data from flat file which would be a string to my sql table of column int...
i have a problem with datatype can i conver string to int how should i do it...new to it
please help!!
This is what the Data Conversion Task is for. U could also use the Derived Column Task. Place it between source and destination, convert your column there.
What more can I say?
Pipo1
|||Use a derived column transformation.This is one example of an expression you could use: (DT_I4)[Your_Column]sql
