In sql database, each table has different structure(number of columns of tables and columns data types will vary from table to table). Each table data into new flat files. Name of the flat file will be table name.
For this, i am getting below error
[OLE DB Source [16]] Warning: The external columns for OLE DB Source are out of synchronization with the data source columns. The column "em" needs to be added to the external columns.
The OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[Department_name] needs to be removed from the external columns.
The OLE DB Source.Outputs[OLE DB Source Output].ExternalColumns[DID] needs to be removed from the external columns.
[SSIS.Pipeline] Error: "OLE DB Source" failed validation and returned validation status "VS_NEEDSNEWMETADATA".
Is it possible to load data for above scenario ?
Mark as Answer if its helpful to you
---
Srihari