DTS using Client Access

#1

I'm importing some AS400 tables into SQL Server 2000 Service pack 3.

For some reason, every table that has a TimeStamp field. when this field is
null in DB2, makes the DTS to stop importing data.

I guess that DB2 400 handles the null dates in different ways SQL does.

Is there any configuration I can set to ODBC driver to avoid this?

I appreciate your help,

Michael Prendergast

#2

When you say DTS stops. What does DTS do ? Hang? Error?

--
--

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

"Michael Prendergast" <m0i0k0e0p0r0e0 (AT) hotmail (DOT) com> wrote

Quote:

I'm importing some AS400 tables into SQL Server 2000 Service pack 3.

For some reason, every table that has a TimeStamp field. when this field
is
null in DB2, makes the DTS to stop importing data.

I guess that DB2 400 handles the null dates in different ways SQL does.

Is there any configuration I can set to ODBC driver to avoid this?

I appreciate your help,

Michael Prendergast

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS using Client Access

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS using Client Access - 08-04-2004 , 04:32 PM

Re: DTS using Client Access - 08-04-2004 , 11:56 PM