cheryl9063
asked on
SSIS sum of column
This should be fairly easy for you SSIS pros.. I'm kind of new to it.. I have a OLE DB Source Editor that runs the code below and puts the result into a table in SQL(another OLD DB Source).. The only thing I have inbetween the two OLE DB Source editors now is a data conversion transformation editor..... I need to add something else in between that checks the sum of all [current_onhand] and if 0 then fail the package.. If sum [current_onhand] <1 then.... I would like to avoid the VB script task thing because I'm not a VB person if at all possible.. I'm using visual studio 2008.. Is there a componite to check the sum of a colum and then fail if certain condition is met? I want to stick this in between the 2 OLE DB Sources..
SELECT item_id, item, current_onhand, next_supply, next_supply_date, col1,
col2, col3, col4, col5, creation_date, created_by
FROM sfa.z_item_supply
ASKER
I need help with this.. Not just a link to other sites for me to read.. I put this in the conditional split and I'm getting the error the function sum is not recognized when I try to click the configure error output.
see attached screen print
sum([CURRENT_ONHAND])<1...
ConditionalSplit.bmp
see attached screen print
sum([CURRENT_ONHAND])<1...
ConditionalSplit.bmp
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.codeproject.com/KB/database/SSIS_ConditionalSplit.aspx
http://sqlblog.com/blogs/andy_leonard/archive/2009/02/20/ssis-expression-language-and-the-conditional-split-transformation.aspx