I am having problems withing with the Transfer SQL Server Objects task in SSIS.ÃÂ I would like to set the TablesList Property of the task to the value of an expression.ÃÂ At a high level, I need to transfer a table from one server to another but the table name is dynamic so I can't use a data flow task.ÃÂ Each iteration of the package execution will work off of one table so I need to set the TablesList property to the one table.ÃÂ
Since the property is a collection, I am getting errors when I attempt to just assign the TablesList property to the variable value in the expression builder.ÃÂ I get this error:
Error at Copy Table To Production: The result of the expression "@[User::TablesList]" on property "TablesList" cannot be written to the property. The expression was evaluated, but cannot be set on the property.
I also tried to open up the SSIS package in textpad and look at the formatting of the TablesList property and then set the variable to match what I saw in the XML......this gave me the same error.
Any suggestions on how to set a StringCollections property in SSIS?
Thanks in advance,
View Complete Post