In DTS, i would like to identify whether the Alliance table has data,
if has data, then i want to extract the relevant data from another
table called Boolean. After i run the following code, it will return
an error message : Invalid pointer.

if not exists (select * from Alliance)

SELECT catalog_code, category_code, status, supplier_id, description,
start_date, end_date, points_value, supplier_ref, cash_value
FROM Boolean
where len(catalog_code) = 15

Try this in your SQL Task:

if not exists(select * from Alliance)
begin
SELECT catalog_code, category_code, status, supplier_id, description,
start_date, end_date, points_value, supplier_ref, cash_value
FROM Boolean
where len(catalog_code) = 15;
end;

Regards,
Ilona Shulman
Senior Development Consultant, DBA
SSE Inc
http://www.sseinc.com


"tchangmian" <tchangmian (AT) yahoo (DOT) com.sg> wrote

It also didn't worked and come out with the same error.
Actually what i want is when there is no data exist in table Alliance,
then this step(Transformation Task) will run and transform the data
from Boolean to Alliance. While if table Alliance consist of data
already, then this step will run also but do nothing, and also do not
come out an error message. What can i do?
Thanks


"ilona" <ieshulman (AT) sseinc (DOT) com> wrote