Good article Jeff Moden Helped me !!!!

--Check this

SELECT Name,TYPE,Price FROM

(SELECT Name, [TYPE], Price

,ROW_NUMBER() OVER (PARTITION BY NAME ORDER BY PRICE DESC) AS N FROM @t) AS A

WHERE N=1

You are right koen.Initially i got it entirely wrong about my understanding about look up transformation. What i was trying to do

Sales Table as input table and Contact table as...

No then you will have unique rows for each look up id or Contactid

Please refer this if any body has problem with this kind of issue.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ef9fda20-4948-4e3d-920c-3cee07b55ed3?prof=required

Yes i do agree with you guys.Using ranking function makes life easy when deleting duplicate rows

I got the solution what i wanted but not a good solution

SET ROWCOUNT 1

WHILE 1=1

BEGIN

DELETE FROM #Contact

WHERE FirstName IN (SELECT FirstName FROM #Contact GROUP BY FirstName

HAVING COUNT(*)>1)

IF @@ROWCOUNT=0

BREAK

END

SET ROWCOUNT 1

please send me any body has script for this scenario

To have more clarification destination table should look like

ProductID ->716

Name->Long-Sleeve Logo Jersey, XL

ProductNumber->LJ-0192-X

MakeFlag>0

FinishedGoodsFlag->1

Color->Multi

SafetyStockLevel->4

and when i preview the data,this is how the data looks

ProductID ->716

Name->Long-Sleeve Logo Jersey

ProductNumber->XL

MakeFlag>LJ-0192-X

FinishedGoodsFlag->0

Color->1

SafetyStockLevel-> Multi,4

After debugging found issue if SafetyStockLevel is less than double digit

This is how the data should be inserted in the destination table

ProductID ...

Go it resolved

Thanks

I am able to solve this issue

1.Change the data types for the following columns in the source

ProductID - Four byte Signed Integer(DT_I4)

Name - DT_WSTR(50)

ProductNumber - DT_WSTR(50)

2.Add derived...

User derived column to convert the boolean value to a 0 or 1

Expressions what i used in derived column for two columns MakeFlag and FinishedGoodsFlag

MakeFlag ? (DT_BOOL)1...

Can you please send me the expression. Google d to check whether i can get some thing

These are some of the examples i got it

[ColumnName] == "Y" ? (DT_BOOL)1 :...

Sorry for the duplicate post