Re: Bandwidth Problem.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hello Shawn,

The OLEDB drivers between O and SQL Server are notoriously slow. A lot of people pump to text file, FTP then use BULK INSERT. This is the way I would approach this problem.

There are 3 very distinct steps and whilst there are 3 vs 1 step in the other direct trabsfer solution, these steps are simple and clear in purpose.

Allan

I am trying to setup a DTS job that must run every 30 minutes and pull
3.5 million rows from an Oracle database into our SQL2k database. The
job runs fine (2 minutes), but consumes a TON of network bandwidth on
the network card and we have a VERY bandwidth sensitive application
that connects to the db. Anyone have an idea how to deal with this?



.