For my case, i want to check if dun have data exist in the
Rewards_CatalogProducts_CS table, then the data from rd_awards will be
transform into Rewards_CatalogProducts_CS. If
Rewards_CatalogProducts_CS table already exist data inside, then this
step will also run but will not return any error message. Actually i
have 4 steps in DTS, this step is the 3rd step, if this step return an
error message, then it will not run the 4th step. Below is my syntax:


if not exists (select * from Rewards_CatalogProducts_CS)

begin

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

end


The error message i get is:
Error Source : Microsoft Data Transformation Services (DTS) Data Pump
Error Description : Invalid pointer

Are you running this code inside "Execute SQL task" in your DTS?
Regards,
Ilona Shulman

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

Where are you putting this code?
In what task?

Oh hang on it looks as though this is in the DataPump task

What I would do is either

1. You use an ExecuteSQL task to do this with an INSERT statement
2. If you want to use the DataPump then I would have a task up front of it
that checks the count of rows in the table "Rewards_CatalogProducts_CS" If
the count(*) > 0 then you could disable the DataPump task else run it.

#1 will be easier for you


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


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