Hello
I am having the following problem: I have to collect the
same data from multiple data sources into the same table
in SQL server. Instead of writing possibly 150 identical
packages where the only difference is the ODBC connection
i am using, I have set up a generic package which i call
200 hundred times. The very first step to run in this
package is setting the package connection by using a
variable value passed by the caller.

The execution of this generic package is carried out by an
additional DTS package which only serves the purpose of
running the generic package with different context each
time (it has around 200 package execution tasks each one
passing a different value for the ODBC connection name of
the generic package). each time passing a value holding
the name of the ODBC connection, this works fine as long
as I ran 2-3 instances of the package but I dont get the
data when i increase the number of concurrent executions.

The question is:
Is it possible to ran (IN PARALLEL) multiple instances OF
THE SAME generic package by setting its connections to
different data sources? (The destination is the same in
all cases).

In article <05b601c49c77$eb0c4e30$a501280a (AT) phx (DOT) gbl>, Christodoulos
Hadjiodysseos wrote:
You should be able to run n instances of the package at the same time.
You do not say why the packages do not run i.e. Any errors/hang. If it
is a hang then I would suspect locaking on the destination.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know