SQL Server 2000, SP4

I've set up a DTS package that copies records from a DB2
table if one column field equals "N". I was able to set
up a transformation for DateString since I'm moving data
from DB2 to Oracle. However, where there are blank date
fields, those rows don't get copied. How do I get the
blank date fields to transfer over too?

Also, what is the best way to have DTS once it is done
moving the records over to Oracle, to go back to the DB2
table and change the 'N' value to 'Y'?

Mary

Please do not post the same message under different subjects. See my reply
to one of your other versions

--
--

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

"Mary" <Mary_Scheffler (AT) urscorp (DOT) com> wrote

Allan, sorry about the double post, but I never saw the
first message come up after several hours, so I re-posted
again.

As for your reply to the first post, it not showing up
either.

Mary