Post reply

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

  • 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.

  • January 23, 2012 at 6:57 am

    #1437062

    You can set the TablesList property via an Expression.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • January 23, 2012 at 7:10 am

    #1437078

    Can you provide an example of such expression? Tx.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply