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
SQL SQLMSS
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
-RUN

Anyone have an extra "END"?

My code was missing one.