Re: AS/400 to SQL Server 2000 via DTS

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

----- Original Message ----- 
From: "Don" <dr2@xxxxxxxxxxxx>
To: "Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, February 05, 2004 8:54 PM
Subject: Re: AS/400 to SQL Server 2000 via DTS


>
>
> is this a one way conversion?  Are you going to be needing to read this
> file on a on going basis?   If a one way conversion, then just send it to
> .csv and import....usually one of the fastest ways to do a conversion...
>
>
>
> On Fri, 6 Feb 2004, David Bulog wrote:
>
> > Sorry Vengoal can you please dumb down your answer for me
> > Are you talking about the SQL Server box or the AS/400.
> >
> > The AS/400 in question is a very large  iSeries in use by a Telco and is
> > almost completly locked down
> > and protected so I figured this was the most acceptable way to extract
> > data --make up
> > a outgoing stage table--the norm before was the iSeries would ouput txt
> > files to a  drop dir so I figured
> > DTS and ODBC or OLE DB
> >
> > Dave
> >
> >
> > ----- Original Message -----
> > From: "Vengoal Chang" <vengoal@xxxxxxxxxxx>
> > To: "'Midrange Systems Technical Discussion'" <midrange-l@xxxxxxxxxxxx>
> > Sent: Thursday, February 05, 2004 7:40 PM
> > Subject: RE: AS/400 to SQL Server 2000 via DTS
> >
> >
> > > I suggest you use AS/400 toolbox Record Level Access sequence file to
> > > extract table by block will get more good performance than ODBC or OLE
> > > DB.
> > >
> > > Best regards,
> > >
> > > Vengoal
> > >
> > > -----Original Message-----
> > > From: midrange-l-bounces@xxxxxxxxxxxx
> > > [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David Bulog
> > > Sent: Friday, February 06, 2004 4:22 PM
> > > To: midrange-l@xxxxxxxxxxxx
> > > Subject: AS/400 to SQL Server 2000 via DTS
> > >
> > >
> > > Hi all
> > > I wish to extract data from a read only table on the AS/400 and import
> > > into SQL Server 2000 via DTS on Windows 2003 Server
> > >
> > > To access the AS/400 from SQL Server you must have
> > > an AS/400 OLE DB Provider (Prefered one is the Microsoft Host
> > > Integration Server client tools) an ODBC Driver (Client Access
Express)
> > > installed on the SQL Server system that is running DTS.
> > >
> > > My first choice would be to use the OLE DB Provider that comes with
> > > Microsoft Host Integration Server client tools as I know there will be
> > > no issues installing this on Windows 2003 Server--having said that I
> > > have heard that Client Access Express ODBC driver is very robust and
> > > fast.
> > >
> > > My question is /has anyone on the list using DTS (If so what
provider?)
> > > Other question anyone used the OLE DB Provider that comes with
Microsoft
> > > Host Integration Server ?
> > >
> > > Thanks in advance
> > > 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.
> > >
> > >
> > > _______________________________________________
> > > 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.
> > >
> >
> > _______________________________________________
> > 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.
> >
>
> _______________________________________________
> 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.
>