title: Dynamic OLEDB Connections in SSIS
body: <p>I am designing a SSIS package which imports data from one data base to other database. In reality I need to import data from <strong>multiple data source to one destination database</strong>. One way to do, that I know is to use package configuration for all data sources (connection strings) and run multiple instances of the same package. But I want something like, I should provide as many connection strings as I need at a point of time in my config file and my package should connect to each database reading data source connection strings from configuration and imports to my destination table.</p>
  
  <p>Is this possible in any way?</p>