Transfer Objects Fails - Source Table Does not exist
Set up Transfer object to copy one table from a source db to a destination db. Under the Destination Copy Options, wich should be Source Copy Options, under (Collection) I select the tables I want to copy from the source to the destination. When I run the package I get the following error:
Error: 0xC002F363 at Transfer Test Tables, Transfer Objects Task: Table "FiscalMonth" does not exist at the source.
Task failed: Transfer Test Tables.