DTS Import From AS/400 DB2

#1

This is the perfect place to post this message.

I am an AS/400 systems administrator, and an SQL 2000
Administrator. I've found that eliminating any kind of
ODBC connection when transfering data greatly improves
transfer performance. With this said, use FTP to take
your tables down in whole and use DTS packages to parse
the flat files into your SQL Tables. You may have to
deal with omitting columns in your DTS packages, but
overall this will be a much faster alternative.

You might also check the PTF levels on both the AS/400,
and Client Access that's installed on the SQL Server.
Make sure they are on the same level.

Quote:

-----Original Message-----
Hello,

I am new to SQL Server and apologize if this is the
wrong group for this
question.

I currently run several DTS packages to import data from
an AS/400 via
Client Access ODBC. The packages are setup to delete
all rows from my
existing tables then import the data from the AS/400
into them. Ideally I
would like to append only new records from the AS/400
rather than importing
then entire table(s) from the AS/400 (one of my table
has 4.5 million
records) every time the package runs.

Could anyone point me in the right direction?

Thanks,

Jeff
.

#2

Raoul,

Need your help!!

How do I get to FTP the AS400 data? My source table is called xxx911 or
something.
How do I read it afterwards? My process reads 10 million rows every day and
it is getting very annoying!
I really need a better way to extract my information

Please help!

"Raoul Laoyan" wrote:

Quote:

This is the perfect place to post this message.

I am an AS/400 systems administrator, and an SQL 2000
Administrator. I've found that eliminating any kind of
ODBC connection when transfering data greatly improves
transfer performance. With this said, use FTP to take
your tables down in whole and use DTS packages to parse
the flat files into your SQL Tables. You may have to
deal with omitting columns in your DTS packages, but
overall this will be a much faster alternative.

You might also check the PTF levels on both the AS/400,
and Client Access that's installed on the SQL Server.
Make sure they are on the same level.

-----Original Message-----
Hello,

I am new to SQL Server and apologize if this is the
wrong group for this
question.

I currently run several DTS packages to import data from
an AS/400 via
Client Access ODBC. The packages are setup to delete
all rows from my
existing tables then import the data from the AS/400
into them. Ideally I
would like to append only new records from the AS/400
rather than importing
then entire table(s) from the AS/400 (one of my table
has 4.5 million
records) every time the package runs.

Could anyone point me in the right direction?

Thanks,

Jeff
.

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

DTS Import From AS/400 DB2

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

DTS Import From AS/400 DB2 - 09-24-2004 , 07:02 PM

RE: DTS Import From AS/400 DB2 - 10-19-2004 , 01:45 PM