I have an issue with the TransferSQLServerObjectsTask in SQL Server 2005 SSIS.
I have a situation where I don't know the name of the table I need to copy until runtime.
I know I can specify tables at design time but this doesn't help me.
Relative to the TransferSQLServerObjectsTask, how can I...
1) Clear the TablesList collection at runtime... and
2) Add a table name to the TablesList collection at runtime from a variable.
Please post examples as Microsoft has seen fit to either not post examples or when posting examples, they choose to post invalid ones. If your example is code please reply in VB.net if possible. Microsoft's examples of VB.Net using Tasks and the TaskHost object are first and foremost overly complex and convoluted and when used in Visual Studio 2005, don't work.
Excuse the gripping; it's probably my mistake anyway. I used to write VB but when Microsoft abandoned their VB base I said "No Problem", followed their lead and abandonedMS VB.