How to restrict unwanted data coming from Excel Sheet in ssis

  • Hi ,

    I have ssis Package been created to pull out the data from excel sheet and load into sql server table,

    But i want to restrict some of the unwanted data that has been coming from excel file ...

    For ex :

    Excel -is my source data

    Sql server -Table -is my destination data

    In excel i have data of all the countries ,But i need the data of only one country that is "UK" ...

    So how can i avoid getting data other than "UK" in destination table.

    Thanks in Advanced

    jaya

  • There are a few ways to do this,

    You can add a conditional split transformation after the excel data source and split out all records that have country='UK' and send these to your desitination.

    Or you could change the access mode for the Excel Source transformation to use a SQL command and then use the standard Select From Where format of a query.

    Or you could load all the data into a staging table and then select from the staging table Where country='UK'

    I would go for the first option for ease..

  • Thank you so much ....I got the results ...As u said i took up the first option...

    it worked Fine ...

    Jaya

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

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