I am trying to run DTS on Oracle. My OLTP source database is on Oracle 8.1.7 and the destination is also Oracle 8.1.7. I am using Microsoft ODBC driver for Oracle. On an small table (144 rows) the package runs smoothly, takes only 5-6 seconds from command line.

I tried to do some volume testing (about 100000 rows). The DTSrun utility just hangs on a data pump task. Any ideas why this could be happening?

Thanks in advance

People have "complained" that during a large load the Oracle driver is slow.
A lot of people use

Export To Text File
Import using SQL Loader.

That said. Is there any locking/resource issues on the SQL Server ?
Remember the data will need to come through the SQL Server.

--

----------------------------

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


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

driver for Oracle. On an small table (144 rows) the package runs smoothly,
takes only 5-6 seconds from command line.

Allan,
Exporting to test file is not a solution since we are talking huge customer databases here. But going to the later part of your response, does that mean I will have to have SQL server at my customers site. I was of the impression of I store my package as a DTS COM-structured file and execute it with the DTSrun utility I am keeping SQL server totally out of the equation.

You need the DTS dlls to fire a DTS package as a minimum. To get the dlls
you will need SQL Server.

Redistributing DTS with your program
(http://www.sqldts.com/Default.aspx?225)



--

----------------------------

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


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

that mean I will have to have SQL server at my customers site. I was of the
impression of I store my package as a DTS COM-structured file and execute it
with the DTSrun utility I am keeping SQL server totally out of the equation.