"MS" <anonymous@discussions.microsoft.com> wrote in message
news:060701c3daee$6929e210$a101280a@phx.gbl...
> 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?
>

>-----Original Message-----
>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@discussions.microsoft.com> wrote in
message
>news:060701c3daee$6929e210$a101280a@phx.gbl...
>> 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?
>>
>
>
>.