i am creating 1 SSIS package.
there is one oledb source,which getting data from product table.
now from OLEDB source i have 1 excel destination and flat file destination.
what i want to do is if productid > 4 that rows shouls go into excel sheet and if there is problem with data i need to move that to flat file destination.
use the Conditional Split: http://msdn.microsoft.com/en-us/library/ms137886.aspx
- Proposed as answer by btsbee Saturday, September 15, 2012 10:17 PM
i am using conditional split,but it is always that this output has two arrows.
for example,i am giving condition if prodid>4
so 4 rows will go on 1 excel destination, it was giving error,
so i tried 2 excel destination,now first one was successful ,but the one who doesnt satisfy condition r going into second excel destination, and its giving error,(red color)