Hi all,

I want to import Data from my ACCESS Mdb (NULL allowed) to my new SQLServer
2000 Database (NULLs NOT allowed).
The problem is that wenn my DTS-Packages is running I get an error that NULL
Values can't be inserted in my table.
Where can I place a Function or Script or something to convert the NULL
Values from my Access tables to Defaults in my SQLServer Tables?

Greetings

Martin

Why not do that as a SourceSQLStatement instead of specifying the tablename
as the Source ?


--
--

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


"Martin Schmeller" <martin.schmeller (AT) mcs-ag (DOT) com> wrote

Hi Allan,

thank you for answering!

you mean i should use IIF in an JET-SQL-Statement for the
OLEDB-Access-Source-Connection?
Something like this:
SELECT Number, IIF(ISNULL(Searchword),'',Searchword) AS Searchword,
IIF(ISNULL(Version),'',Version) AS Version FROM Version

to avoid NULL-Values to be inserted in my SQLServer-Dest.-Database!?

Greez

Martin



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:OOEBR6ttEHA.1176 (AT) TK2MSFTNGP11 (DOT) phx.gbl...