December 30, 2010 at 10:25 am
Using SSIS, I have requirements to validate a transaction of type VOID. If the system logs a VOID Transaction, it should make sure it matches the exact previous accepted transaction it is voiding. I have this part done. However, the requirement includes a search of all transactions back x number of seconds for a match if the previous transaction is not a match. Using the Lookup Transform - I cannot edit the sql command to search all transactions for date range between transaction_time and transaction_time plus x seconds. The sql command only allows for exact matching. HELP?
December 30, 2010 at 11:47 am
You should review the options presented in this Range Lookup post by the SSIS Dev Team.
Todd McDermid - SQL Server MVP, MCTS (SQL 08 BI), MCSD.Net
My Blog - Dimension Merge SCD Component for SSIS - SSIS Community Tasks and Components
December 31, 2010 at 1:42 pm
This was very helpful - thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply