Microsoft SQL 2000
Windows 2000 Server

Puzzling occurance. One of our DTS packages transfers data
from the AS/400 to an Oracle server. In our test
enviroment, data is appended to the Oracle table and
whenever the record count gets beyond 2 million, DTS
doesn't transfer any data over.

The package executes via a job, and runs and runs and
runs, but again, no data is moved. No error logs are
written since it keeps running and the only way to end the
package execution is to cancel the job.

The Oracle table doesn't have any limitations on its
growth size, nor is there a problem with the free space on
the hard drive. The Oracle DBA doesn't see any issues on
the Oracle side.

We use DataDirect's Wire protocol ODBC driver for Oracle,
so should we be looking at some configuration setting with
the driver, or something else?

Have you set the workflow pproperties to "Close connection on completion"?
Does it do things fine manually?
If so how long does it take?
If you choose a smaller count of rows to move does it work?


--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"MS" <anonymous (AT) discussions (DOT) microsoft.com> wrote

No, we didn't set the last workflow to close the
connection. I have deleted the last workflow and
recreated it with connection close upon completion.

We have been able to manually insert data into the Oracle
table. It takes very little time to populate the data
into the table.

We haven't tried moving a smaller number of rows over yet.

MS