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