Hi!

I'm transforming data from a SQL Server to another, what is a CHAR(10) in
one table is a DATETIME in the other. The format of the string is
YYYY-MM-DD, and this is handled excellent by DTS as long as the string has a
value. However, when the string is empty (10 spaces), I want to put a NULL
value in the DATETIME column. I only get an error when I try now. What do I
do to make it treat empty strings as a NULL for the DATETIME column?


Sincerely,
Nils Magnus Englund

Does this do it. This should be placed in your SourceSQLStatement.

NULLIF(<attribute name>,' ')

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Nils Magnus Englund" <nils.magnus.englund (AT) orkfin (DOT) no> wrote