Problem Extracting data from AS/400

#1

Hi, I have a schedule DTS that extract data from AS/400
tables using Client Access V. 4.4. A Table that have 4
fields (2 are char). The char fields some times load good
and others load blank. But sometimes a records load good
and other times load bad, when I run manually the DTS
always load good.

My SQL Server is 2000 Enterprise SP 3.

Something can help me.

Thanks. Cesar.

#2

Make sure you have the correct client acces version and the
correct CA patch level on SQL Server.

-Sue

On Tue, 14 Oct 2003 11:54:46 -0700, "Cesar M"
<cesarnm (AT) hotmail (DOT) com> wrote:

Quote:

Hi, I have a schedule DTS that extract data from AS/400
tables using Client Access V. 4.4. A Table that have 4
fields (2 are char). The char fields some times load good
and others load blank. But sometimes a records load good
and other times load bad, when I run manually the DTS
always load good.

My SQL Server is 2000 Enterprise SP 3.

Something can help me.

Thanks. Cesar.

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

Problem Extracting data from AS/400

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

Problem Extracting data from AS/400 - 10-14-2003 , 01:54 PM

Re: Problem Extracting data from AS/400 - 10-16-2003 , 05:37 PM