Post reply

How to remove strings from Integer valued Column

  • December 9, 2009 at 6:25 am

    #135809

    I have one ID column which have some string values. While importing I have to replace those strings with Null value.

    In derived column for SSIS I have used replace function to replace one String Value but I am left with another value.

    Any idea how can we remove all string values(whatever values apart from integer) while importing data into integer column.

    or

    Any other way to tackle two situation only

    1) Getting values of NA in some cells

    2) Getting some date values in some cells

    Thanks in advance for any help.

  • December 9, 2009 at 6:49 am

    #1089795

    How can we use search string function in SSIS.

    Thanks,

  • December 9, 2009 at 7:08 am

    #1089817

    <<while importing data>>

    You could avoid a huge headache by importing your data into a staging table first, then pouring it into your real table. The staging table can have any structure you like - the closer it is to your data source, the less likely you are to have problems getting it in there.

    Once you have it, you can frig around with it as much as you like to make it fit into the target table.

    “Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw

    For fast, accurate and documented assistance in answering your questions, please read this article.
    Understanding and using APPLY, (I) and (II) Paul White
    Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

  • December 9, 2009 at 7:54 am

    #1089857

    [font="Comic Sans MS"]

    If this is allowed in your environment - system architecture - try using some text persing tool to get this done. I personally prefer using tools to do what they are best at ..

    you can use small perl - sed code snippet to do the initial formatting for you. Then load 'clean' data. I am sure - some clever script task would also do the same for you..

    Other than - the staging table is the best probable approach for you (they are meant for this - temporary table to 'clean up' the data 😎 ).

    [/font]

    [font="Comic Sans MS"]--
    Sabya[/font]

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

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