Hi,
I have created an SSIS package that extracts data from a flat file source, then loads the data into an SQL Server database. I would like to use package configurations to change the destination dynamically, i.e change the database to a new one as the destination. please help. I have tried the XML config type, but to no avail.