Configuration for Configuration Package? Is this Possible?

Hot Topic

Server goes slow roughly every 24 hours
Deploy SQL 2005 Management Studio Tools
Error occurring in ExecuteSQL Task in OnPreExecute (and in OnPostExecute) but package not failing
Can't drop trigger assembly
How to reference different databases on different servers in one query
Mdx query
Transfer Logins and passwords to another server
VB2005 can't connect to SQL Server 2000 file?
Need SQL for distinguishing SQL 2005 from 2000 and 7.0
Connecting to Sybase

SQL Server

Transferring Records from a table to multiple files
How can I use SMo in VS 2002 SP1 c# applications?
convert millisecond to "hh:mm:ss" format
question on namespaces
How to ignore timepart when using LookUp with date.
PIVOT question
Failed to acquire connection tempdb
cant access report manager options
Time series calculation
Variables Not Seen In Custom DataFlow Destination

Configuration for Configuration Package? Is this Possible?

Hi Guys,

Here's the current scenario:

I am creating a windows application to manage my ssis packages.

My SSIS packages use package configurations, and by default connect to the "SSIS Configurations" table in sql server.

However, I want it to connect to a view instead of this table, so i create a view "vwSSIS_Configurations" and point the package configuration to use the view in sql server.

The application SHOULD be capable of altering the package configuration's configuration and switch its connection between the default "ssis configurations" table, and the view.

Is this possible I cannot think of a way which I can have my application switch the package configuration's connection.

Thanks,

kervy

Answer this question

Configuration for Configuration Package? Is this Possible?

ShaneCourtrilleDev

Ah OK. Well I've just looked at the setup screen for SQL Server configs for the first time in my life and seen that you can store the config location in an environment variable. I don't know exactly what it does but have you explored that BOL should contain details to help you.

-Jamie
OOC#

There are a number of ways. I would store the connection string of the connection manager in an XML configuration file.

-Jamie
CloudedTurtle
it's not the connection string of the connection manager, but the connection to the package configuration table,

currently my package configurations are looking in the "SSIS Configurations" table.. but I want my application to let the dtsx switch to another configuration table named "SSIS Configurations2" both have the same schema but different values. is there a "configuration" property for the configuration table connection
Configuration for Configuration Package? Is this Possible?

Answer this question