mixed data columns

  • I currently have a column that have both numeric and characters:

    Example: 3

    PF

    11

    PF

    PF

    3

    3

    I am trying to pull the data like this into ssis and send it to a sql table.

    What I get are NULLS when I do DT_NUMERIC and DT_STR will not pull it in either. Did anyone had this problem and came up with an answer?

    Kind regards

    Fred

  • What are the settings for the column in the table you are trying to pull this data into?

    --------
    For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
    You can also follow my twitter account to get daily updates: @BLantz2455

  • Hi there

    My column is currently set up as varchar but will change it to the required field if need be.

    Kind regards

    Fred:-)

  • frdrckmitchell7 (4/24/2013)


    Hi there

    My column is currently set up as varchar but will change it to the required field if need be.

    Kind regards

    Fred:-)

    Have you changed the data type in the table and if so, from what?

    --------
    For SQL Tips, check out my blog: http://lantztechknowledge.blogspot.com/[/url]
    You can also follow my twitter account to get daily updates: @BLantz2455

  • Why not split the two types out inside SSIS:

    select someData, ISNUMERIC(someData) As NumTest

    from test

    WHERE ISNUMERIC(someData)=1;

    The example is kind of overdone, but the idea is that you can test/filter for whether the column contains numeric data, and route that data inside your dataflow... and just send the non-numeric data into a different one.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply