Home Forums Data Warehousing Integration Services How to use same connection manager in different control flow tasks? RE: How to use same connection manager in different control flow tasks?

  • here are a couple of options:

    1. Kill any SPIDs with open connection then manually set to Single User mode.

    2. Take the database Offline, dettach databawse, copy MDF and LDF files (and any other database files) to the second instannce and attach to new instance. Attach back to current instance. MAKE SURE YOU COPY THE FILES, DO NOT MOVE THE FILES.

    Thanks,

    Thomas LeBlanc, MVP Data Platform Consultant