Hello everyone:

I am trying to run a particular task only when there are available records in a table.

I have a Task containing a simple SQL Statement, like this:

SELECT COUNT(UserID) AS RecordCount
FROM  CX.Tracking
WHERE TrackingDate > DATEADD(MI, - 1, GETDATE())

I created a local variable with Scope of Project as follows and here is the rest of the setup:



The task runs fine but it does not got to the next task.

Can someone please tell me why or provide me some explanation to fix this?

Thank my friends.

First of all step 2 is NOT required, if it is just used for the next task (generate CSV....). Secondly, try setting step 4 as

@RecordCount>=1		

First of all step 2 is NOT required, if it is just used for the next task (generate CSV....). Secondly, try setting step 4 as

@RecordCount>=1