Parameter driven data connections

I would like to use the same report for different business units and each
business unit has their own SQL server db (for security reasons).
I would like to have a Business Unit parameter that would change the
connection to the appropriate database. Any suggestions on how to do this?
Is it even possible?
TIA
DeanI have found the answer to my own question, for others that may be
interested see ths 2005 BOL at
http://msdn2.microsoft.com/en-us/library/ms156450.aspx
"Dean" <deanl144@.hotmail.com.nospam> wrote in message
news:%23MDFCA8zHHA.5948@.TK2MSFTNGP03.phx.gbl...
>I would like to use the same report for different business units and each
>business unit has their own SQL server db (for security reasons).
> I would like to have a Business Unit parameter that would change the
> connection to the appropriate database. Any suggestions on how to do this?
> Is it even possible?
> TIA
> Dean
>sql

Parallelism in SSIS

Hi,

I would just like to confirm something with you guys...

Am I correct in saying that you dont need multiple connections to the same DB in a SSIS package in order to achieve parallel processing across multiple SQL tasks. In other words, I have 2 SQL tasks executing different stored procedures on the same DB that I want to run in parallel. They should be able to share one connection and still process in parallel, correct?

With that in mind, would the processing be faster if they each had their own connection?

Thanks in advance.

GBez wrote:

Hi,

I would just like to confirm something with you guys...

Am I correct in saying that you dont need multiple connections to the same DB in a SSIS package in order to achieve parallel processing across multiple SQL tasks. In other words, I have 2 SQL tasks executing different stored procedures on the same DB that I want to run in parallel. They should be able to share one connection and still process in parallel, correct?

They can share a connection manager but they still maintain seperate connections to the database. This is a good thing by the way.

GBez wrote:

With that in mind, would the processing be faster if they each had their own connection?

No. it wouldn't make any difference.

-Jamie