Re: Data Transfer from Oracle to SQLSRV is very slow

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

From: stephane (stephaned_at_softhome.net)
Date: 08/03/04 

Date: Tue, 3 Aug 2004 16:33:30 +0200

Hi Ilya,

I tried to put the Select statement in an ExecuteSQL task,
but it seems, that ExecuteSQL doesn't wait the results to fire Success ....
but just syntax validation.(Am I wrong ?)
I currently investigate on the Oracle query's joins that seem to not to be
as simple as it was at first look ....

thanks,
Stéphane

"Ilya Margolin" <ilya_no_spam_@unapen.com> a écrit dans le message de
news:%239$sK7VeEHA.2852@tk2msftngp13.phx.gbl...
> Stephane,
>
> Can you change data pump to execute sql task with insert/select?
>
> Ilya
>
> "stephane" <stephaned@softhome.net> wrote in message
> news:u3uHsvKeEHA.3428@TK2MSFTNGP11.phx.gbl...
> > Hello everyone,
> >
> > In a DTS package I have a datapump that results in a Time way : 7
minutes
> > to transfer 957 rows !
> > (about 30 fields, varchars and decimals fields, nothing specially
heavy).
> >
> >
> > The source is a quite simple SELECT on several tables with inner joins
> > against an Oracle Database (through OLE DB),
> > the destination is a unique table with no index, no trigger.
> > No activeX transformations ...
> > I tried to increase the fetch buffer .... with no effect ...
> >
> > The source query runs in 2 secs without the transfer
> >
> > May I missed something ?
> > Thanks in advance for your help.
> > Stéphane.
> >
> >
>
>

Relevant Pages

  • Re: Missing Global Variable parameter mapping
    ... Does that work everytime. ... The ExecuteSQL task is just ... > problems later in the package because it thinks it should be copying zero ...
    (microsoft.public.sqlserver.dts)
  • Re: which authentication mechanism should I use?
    ... If you are going to use the ActiveX approach then the above is all you need. ... Set the SQLStatement property of the following ExecuteSQL Task ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS from C#
    ... Did you install an unhandled exception handler to catch exceptions that do ... > I have a DTS package that works perfectly fine from within Enterprise ... It has an ExecuteSQL task to clear a table, ...
    (microsoft.public.sqlserver.dts)