Afternoon all,
I am currently writing a dynamic data load process using SSIS, whereby I store the names of the tables I want to load into an object (Execute SQL Task), and then using a Data Flow Task within a Foreach Loop, connect to the Source Server and load the Data
into the Target Server. I am currently having trouble bypassing the metadata differences on each pass of the loop, as the column mappings change for each table it is trying to process. I have tried ignoring the meta data validation settings within the Advance
Properties of the source and target connection within the Data Flow Task. I have also tried to delay the validation between each pass to no avail.
Firstly, is it possible to do this using different table structures with different metadata out of the box? (SQL Server 2012) I have setup configurations previously using tables with the same schema at multiple sources into one single target, but not where
on each iteration of the loop, the table metadata changes at source and destination. I have found conflicting information on Google, where some say it's possible (but are using the same method I am using), and others who say it isn't possible.
Advice much appreciated in advance!
Cheers!
Edit:
The external columns for <Target> are out of synchronization with the data source columns.
