I am a great fan of using Package configuration in SSIS to ease migration. I am stumped when it comes to sql execute task. We have few execute sql task that requires selecting/updating across mutliple databases in the query. Currently, I am using 4 part
name(server.database.schema.table) in query. Doesn't this actualy against theme of using package configuration in SSIS. If I hard code server and database name, I will have to edit each SSIS package post migration to production.
What options do I have? Can you please help this rookie?
View Complete Post