Populate and use ObjectsToCopy collection using an expression - Transfer SQL Server Object Task

• pkrudysz

  Right there with Babe

  Points: 772

  More actions

  January 23, 2012 at 3:43 am

  #255334

  How can I populate and use ObjectsToCopy collection of Transfer SQL Server Objects Task using an expression (or script)?

  Goal: to copy only tables that have names starting with 'tmp'. The number of tables can change - the package must deal with that.

  Thanks.

• Phil Parkin

  SSC Guru

  Points: 247159

  More actions

  January 23, 2012 at 6:57 am

  #1437062

  You can set the TablesList property via an Expression.

  ---

• pkrudysz

  Right there with Babe

  Points: 772

  More actions

  January 23, 2012 at 7:10 am

  #1437078

  Can you provide an example of such expression? Tx.