Re: AS/400 to SQL Server 2000 via DTS

Hi Evan,
Thanks for the tip re CPYTOIMPF and CPYTOSMTF
Im a bit rusty as I no longer have the trusty  Model 500 to set up a test
lab trial
I still think ODBC or OLE DB access is much better--problem is I cant seem
to find anyone
who has tested the Microsoft  OLE DB provider that ships with Host
Integration Server.
It would be a shame in this day an age to resort to file output

cheers Dave


----- Original Message ----- 
From: "Evan Harris" <spanner@xxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Friday, February 06, 2004 7:32 PM
Subject: Re: AS/400 to SQL Server 2000 via DTS


> Hi Dave (long time no hear)
>
> If this approach will work then when discussing CSV with your 400 guys be
> sure to mention the CPYTOIMPF and CPYTOSMTF commands. They ought to be
able
> to create a CSV file in a directory that is shared via Netserver with very
> little effort.
>
> Regards
> Evan Harris
>
> >Hi Don,
> >Nice point re CSV - Our A/S400 guys seem to loke to give you a txt file
with
> >header and trailer records looks rather like a printer spool file
> >--a nightmare to process so I going to be firm and find out why they cant
> >provide CSV! This will be 10 megs of data collected during day -ongoing
> >
> >ODBC or OLE DB is much much better-avoiding file management  which can be
> >error prone
> >
> >cheers Dave
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>