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.
>