related to connection manager in ssis.
Please tell me how to optimize use of connection manager specially in case of oledb connection manager.
I want to dump data to nearly 30 tables present in same database. These tables are independent can i use a single connection manager and execute them paralally or more connection managers will be
required,or Data source will be a better alternative.