December 9, 2009 at 5:50 am
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
December 9, 2009 at 5:57 am
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..
December 9, 2009 at 6:22 am
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