Hello,

I am running an extract and need to be able to specify that if the Source
field is Null it picks up another field. For Example:

SOURCE DESTINATION
--------- ----------------
FieldA FieldC
FieldB

If Field A is Null, Copy Field B to Field C.

Any assistance would be appreciated.

Regards,
Brent

In article <DBB2EEC3-FDBA-4AD0-98CA-9533BB2FF1CC (AT) microsoft (DOT) com>, Brent C
wrote:

You do not specify the provider. In SQL Server you can do this in the
SourceSQLStatement

SELECT IsNull(col1, Col2) as MyVal...........

If you are using another provider they may have an equivalent syntax. Short
of this you can do it by using an Active Script transform.



--

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