I have a Process Flow that has four steps. First af course Start. Followed by a stored procedure deleteing the last five days of a transaction file. Then a Stored procedure to put the current date less 5 into a varable. Then process all transactions within the 5 day window.
I can get each indivudal part to run. However when placed in any order the SQL based procedure causes an end to processing. It works but the flow ends.
I have the connection arrow set for unconditional, but it is never followed.
Any guess why?
See Yall in Orlando
ENGINE SQLMSS SET DEFAULT_CONNECTION CABLEATL
DELETE FROM DM_SHIPPING_DETAIL
WHERE ([Creation Date] >= DATEADD(DAY, - 5, GETDATE()));
-SET &CURR_DATE = &YYMD ;
-SET &&AS_OF_DATE = &CURR_DATE - 5 ;
-TYPE Current Date is: &CURR_DATE
-TYPE As of Date is: &&AS_OF_DATE
Anyone have an extra "END"?
My code was missing one.
|Powered by Social Strata|