Can you create one connection manager that accepts the Server name and database name at run time and constantly reuses the server and datbase name at runtime when executing one SSIS solution with Multiple packages.
You can use Expressions property in your connection manager to build the connection string at run time. You might also want to use package configurations to 'pick up' the right values from a configuration file/table.
Jamie has something about it on his blog,
http://blogs.conchango.com/jamiethomson/archive/2006/03/11/3063.aspx
Rafael Salas
No comments:
Post a Comment