locked
SSIS Derived Column Query RRS feed

  • Question

  • Hi all,

    I am porting data from flat file(Souce) to oledb destination table

    in destination table i am creating table this format (no int,name varchar(50))

    but in source column1,column2 values

    column1,column2
    1,Ram
    2A,Gopal

    in source column1 mapped to destination column1(no) in destination table "no" is int datatype so in source i want to pick only numeric values for no column how to do?

    Output should be this format
    column1,column2
    1,Ram
    2,Gopal

    Thanks
    Ram Gopal

    Friday, November 2, 2012 7:45 AM

Answers

All replies