DTS Copy Objects Task - Dynamic Destination

• crimsonie

  Grasshopper

  Points: 19

  More actions

  April 5, 2009 at 3:07 pm

  #72607

  I have a DTS package that contains a 'Copy SQL Server Objects' task.

  The source database is remote (with web hosting company) and the destination is a local instance of SQL Server 2000.

  Is it possible to dynamically set the local database name at run time in the Copy SQL Objects task?

  i.e

  A scheduled package where Destination Server = "(local)" and Destination Database = "_dynamically assigned name_"

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  April 5, 2009 at 8:49 pm

  #972252

  Use the dynamic properties task to find the name (query, file, etc) and then you can use a script task to change the name

  This might help: http://www.sqldts.com/241.aspx