Re: AS/400 to SQL Server 2000 via DTS

["David Bulog" <d2ba@xxxxxxxxxx>]

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