|
Home > Archive > MS SQL Server DTS > July 2005 > Delay on execution
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Delay on execution
|
|
| Marc Busch 2005-07-12, 7:26 am |
| Hi NG,
I have a problem with delay when executing packages.
I have 4 packages which are actual "clones" of the first package; I only
changed connections, then "Saved as...".
They import data from an UNIX-System into SQL.
Very first task is an ActiveXSkript (VB) to set Variables and
Transformation-SQL-Strings,
and eventually open an InputBox (for manual execution).
When I execute the "original" package 1, it starts fine, InputBox appears
immediatley etc.
But strange: most of the time when I execute package 2-4, it needs a long
delay in the ActivXScript-Task.
Only eventually they run without this delay.
All settings are identical.
Because the packages are included in another "big" package, to be executed
plenty of times in a loop, I need to fix this.
Does anyone know what this is about ??
System: Win2k3 Standard, SQL 2000 Standard
Thx in advance,
Marc
| |
| Ilya Margolin 2005-07-13, 9:23 am |
| Marc,
How long is the delay? Is this right at the start of a package? You may
experience some delay if you go through a linked server for say a package
name resolution or package logging.
Ilya
"Marc Busch" <marc.busch@itvt.de> wrote in message
news:%23gpuEothFHA.2644@TK2MSFTNGP09.phx.gbl...
> Hi NG,
>
> I have a problem with delay when executing packages.
>
> I have 4 packages which are actual "clones" of the first package; I only
> changed connections, then "Saved as...".
> They import data from an UNIX-System into SQL.
> Very first task is an ActiveXSkript (VB) to set Variables and
> Transformation-SQL-Strings,
> and eventually open an InputBox (for manual execution).
> When I execute the "original" package 1, it starts fine, InputBox appears
> immediatley etc.
> But strange: most of the time when I execute package 2-4, it needs a long
> delay in the ActivXScript-Task.
> Only eventually they run without this delay.
> All settings are identical.
>
> Because the packages are included in another "big" package, to be executed
> plenty of times in a loop, I need to fix this.
>
> Does anyone know what this is about ??
>
> System: Win2k3 Standard, SQL 2000 Standard
>
> Thx in advance,
> Marc
>
>
| |
| marc.busch@itvt.de 2005-07-21, 3:23 am |
| Hi,
it's about 10-20 seconds, right at the start. I don't use linked
server, only connections through ODBC to UNIX, and to the local
sqlserver, but later in the package.
Marc
Ilya Margolin wrote:[color=darkred
]
> Marc,
>
> How long is the delay? Is this right at the start of a package? You may
> experience some delay if you go through a linked server for say a package
> name resolution or package logging.
>
> Ilya
>
> "Marc Busch" <marc.busch@itvt.de> wrote in message
> news:%23gpuEothFHA.2644@TK2MSFTNGP09.phx.gbl...
|
|
|
|
|