SSIS: How to set a Expression value from SQL Executable Task

Question

I have a SQL Executable task in which I am checking the count(*) of records in a particular table.

select count(*) as Is_Data from TABLE_NAME;

I need to get the Is_Data value out as an expression, so that based on the value the next execution start.

How to get the Is_Data value out from SQL Executable task

Thanksc

Mark Wojciechowicz · Accepted Answer · 2022-07-18 15:00:52Z

1

Set the ResultSet to single row:

Configure a variable on the Result Set tab. This variable can then be used in subsequent tasks:

answered Jul 18, 2022 at 15:00

4,4871 gold badge20 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1