Home Forums SQL Server 2005 SQL Server 2005 Integration Services Dynamically changing Server info for OleDB Connection RE: Dynamically changing Server info for OleDB Connection

  • August 16, 2010 at 11:31 am

    #1207497

    Baskar B.V (8/16/2010)

    I hope this dynamic mapping would not help inside data flow task. Because even if you map server name to the connection at run-time you can't do the column mapping dynamically between source & target in the data flow task.

    You may need to try to achieve this in your control flow using execute sql task based on your need.

    Thanks Baskar.

    The structure across all the databases on different servers will be the same, so that is not a concern.

    -Sid