My project environment includes 2 databases DB1 and DB2 of SQL Server 2008.
I have an SSIS package designed with source from DB1. The package configuration for this package is set with Initial Catalog property being selected. There is a chance to change the database name from DB1 to DB2 in the future.
My requirement is to send an email to the team saying which database DB1 or DB2 is used for the execution.
I tried with variables but could not make it? Any help would be highly appreciated.
View Complete Post