Home Forums SQL Server 2005 SQL Server 2005 Integration Services SQL Database Name Change - How to handle this in SSIS on SQL Tasks RE: SQL Database Name Change - How to handle this in SSIS on SQL Tasks
ManicStar
SSCoach
Points: 17992
More actions
July 11, 2013 at 11:41 am
#1631702
Use a variable to overrride the connectionstring property of the connection connecting to your everchanging database.
You can set the contents of the variable to components of getdate() to look for the current version of your sql database.