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,

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 (AT) itvt (DOT) de> wrote

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: