Hello,
I am trying to create a program flow using DTS. Though I can achive the same thng using SP and a job but want to use DTS.Here is my question

I am connecting a global variable as @Rowcnt and running the following query to intialize that
SELECT
COUNT(*) AS ROW_COUNT
FROM
S_ORG_EXT_FNX (NOLOCK)
WHERE
LAST_UPD > ?
AND LAST_UPD <= ?

I am creating a output variable @Rowcnt int and assigning ROW_CNT to it. AFter this step succeeds, I want to go to next step and run the following query.

IF @Rowcnt > 0

TRUNCATE TABLE UA_TS_CMS_SELLER_STAGING

When I am running the query it says: "Must declare Variable @Rowcnt".

Basically I want to know how can I access the global variable, programmtically like if ..else, while statements in a SQL Task in DTS Designer.

Thanks in advance

SK

In an Active Script task you can use Workflow

if Cint(DTSGlobalVariables("Rpw_Count").Value) > 0
'Enable the TRUNCATE step
Else
'Disable the TRUNCATE step
End If



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"SK" <SK (AT) discussions (DOT) microsoft.com> wrote

question
query.
Designer.