multiple users running the same SSIS package simultaneously- possible?

[wanderingaround]

Hello!

I wonder if this is possible.

I have an SSIS package which imports data from a couple of sources, uses fuzzy lookup and writes results to a table.

Is it possible for multiple users to call the same SSIS package (possibly simultaneously)?

Here's a little more detail:

A front end passes a name and address (source 1) to the package. Source 2 is the database. The fuzzy lookup component checks for matches and writes results to a table. At the moment the process is only ever run by one user.

Any thoughts or opinions on this greatly appreciated!

 

[fredericofonseca]

as long as the underlying data/process allows for more than one user, the package does not care about how many are running it.

For example on your case the table the package writes into needs to be a per user type. e.g. results from one user probably should not be seen or retrieved by the other user running same package

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886