Hi,

I have created a package to process Analysis Services (AS) databases. I am
currently using variables to store info such as the Connection and the
Initial Catalog (AS database) and these variables are loaded from a
configuration files (stored in the SQL Server).

I now want to call this package using a different filter value, is this
possible?

i.e.

1) Filter Value = FINANCE ,
Variables: Initial-Catalog=FINANCE Cube, Connection=DSS\DVT

2) Filter Value = PAYROLL
Variables: Initial-Catalog=PAYROLL Cubes, Connection=DSS\DVT

3) Filter Value = SALES
Variables: Initial-Catalog=Sales Cubes, Connection=DSS\PRD


Im still not sure if a configuration file is the right technology to use
here, is it possible to load these variables at run time by just passing in
the filter and extracting these from a table using a query?

Any assistance here would be greatly appreciated.

Thanks
Mick



I was wondering if anyone had any good exa

AS databases. and be able to use a package configuration file to hold
connection details and other variables.

I created a configuration file and stored it in the database, I also added
additional records for other

In your configuration file you can set the connection properties directly so
there is no need to go through a variable

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Mick Anderson" <Mick Anderson (AT) discussions (DOT) microsoft.com> wrote

thanks Allan, is there any way you can supply a filter. i.e. I want to use
the same package but pass in a different filter to pickup the connection
properties and variables.

Thanks
Mick




"Allan Mitchell" wrote:

That's the beauty of configuration files. The package picks up the
configuration applies the settings and off it goes. In the configuration
setup you export what you will be wanting to change through the
configuration. You then change the value in the configuration to be
whatever you want it to be without having to touch the package again.

Make sense?

--


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com


"Mick Anderson" <MickAnderson (AT) discussions (DOT) microsoft.com> wrote

Hi Allan,

so can I call a package with a package filter, or do I need to update the
values configuration each time I run the package?

i.e.

dtsexec myPackage.dtsx "Filter=SALES"

or

dtsexec myPackage.dtsx "Filter=PAYROLL"

Thanks
Mick

"Allan Mitchell" wrote: