Ssis Doubt

[chittigaadu]

i have a derived coloumn and a destination OLEDB
when ever i run this package..naku output correct gane vasthundi..but enni sarlu chesthe anni kotha records vachesthunay.
so duplicate records rakunda emaina cheyacha?

[deals2buy]

SQL Task or Script Task raayi to pull only Distinct records

[king420]

[quote name='chittigaadu' timestamp='1360510224' post='1303254802']
i have a derived coloumn and a destination OLEDB
when ever i run this package..naku output correct gane vasthundi..but enni sarlu chesthe anni kotha records vachesthunay.
so duplicate records rakunda emaina cheyacha?
[/quote]

Add a SQL command task at the begging of the package and add a SQL query to

1) To clear existing data every time before the package runs...if you dont want old data
2) Duplicate records kuda vastunnai ante...you have to work something on constraints ....It should not take duplicate records.

[deals2buy]

[quote name='HAPPYNESS' timestamp='1360511011' post='1303254830']
Add a SQL command task at the begging of the package and add a SQL query to

1) To clear existing data every time before the package runs...if you dont want old data
2) Duplicate records kuda vastunnai ante...you have to work something on constraints ....It should not take duplicate records.
[/quote]


vuncle neeku SQL Server kuda vacha?

[pachimirchi]

[quote name='chittigaadu' timestamp='1360510224' post='1303254802']
i have a derived coloumn and a destination OLEDB
when ever i run this package..naku output correct gane vasthundi..but enni sarlu chesthe anni kotha records vachesthunay.
so duplicate records rakunda emaina cheyacha?
[/quote]


src lo enni rows vunte destination lo anne rows ostai madyalo nuv derived column pettina sare.. src lone duplicates lekunda query rasko.

[chittigaadu]

Thank you!

[ghazni]

incremental load ani search cheyi google lo...........