forum.venkateswarlu.net
      Register      Login
Data flow task

2 replies to this topic

Ravi kumar reddy Goli #1
Member
14 Points
 Posted on 19 Mar 2012 06:10 AM IST anyone tel me
how to used where clause n data flow task & how to delete duplicate 25 record's in meta data type? 
SSIS     900 views     Reply to this topic
Harikrishna Sikhakolli #2
Member
108 Points
 Replied on 20 Mar 2012 02:59 PM IST Mainly where clause is used for filtering data in a table based on a condition.Conditional split transformation is used to apply such type of conditions.To remove duplicate records from a table using sort transformation(check box is available to remove duplicates just check it) in data flow.
 
Reply to this topic
Dhirendra Prajapati #3
Member
34 Points
 Replied on 21 Mar 2012 06:25 AM IST you can use this query....

DELETE
FROM MyTable
WHERE ID NOT IN
(
SELECT MAX(ID)
FROM MyTable
GROUP BY DuplicateColumn1, DuplicateColumn2, DuplicateColumn3) 
Reply to this topic