Can I implement this logic in my DTS package?

IF GlobalVariable1 = '0000' THEN
do transfromation1 (parameter1)
ELSE
do transformation2 (parameter1,parametyer2)
END IF

What do you consider to be a transform?

A transform in DTS is the mapping of 0-n source columns to 1-n output
columns in a 1-n Data Pump tasks

Do you mean that you want to execute a Datapump task based on certin values
of certain variables?

If you do then this is conditionl workflow and examples can be found here

Workflow
(http://www.sqldts.com/default.aspx?103)

--

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


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

Thanks Allan,

One of my co-workers already
directed me to thisd SQLDTS.COM link.
But anyway thank you very much.

Allan,
I used Transfromation because
the tast is called "Transfrom Data Task".
What is the standard in DTS community?
How should I refer to it?
DataPump?

Regards,
Robert Opeshansky




"Allan Mitchell" wrote:

Ahhh

I see why you used the word transform.

I use DataPump task for the Transform data task and a transform is the black
line/s between the Source and destination columns

--
--

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


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