hello all,
I have a scenario where I like to reuse one project from one machine to another machine.
- Server name is variable.
- database name is variable
- table name is fixed.
How do I specify a variable name for "server name" and "database name" ?
Are you taking about Server/Database name of your Data Sources?
For that you can use package configurations storing those names in a table, xml file, etc
Rafael Salas
|||You can select the connection manager then go to the properties pane to set the expression for these properties. In your case, you'd want to change the server name and initialcatalog properties, which are very common. You could set these to a variable of course like in your requirement and then additionally later use a configuration file to externalize this all.
Also, the same type of concepts in this video would help you as well: http://www.jumpstarttv.com/Media.aspx?vid=34
-- Brian Knight
No comments:
Post a Comment