Need to load all tables of a database into flat files.

Posted by Sriharim under Sql Server on 5/29/2015 | Points: 10 | Views : 512 | Status : [Member] | Replies : 1
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 ?

---
Srihari



Responses

Posted by: Bandi on: 5/29/2015 [Member] [MVP] Platinum | Points: 25

Up
0
Down
may be you are using Flat File Destination and OLE DB Source in Data Flow Task... Obviously, it will generate that error....... the dynamic metadata cannot be generated in OLE DB source...

Use Script Task to generate flat files dynamically.... refer the below link
http://sqlage.blogspot.in/2014/11/ssis-how-to-create-flat-files-for-all.html



Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Sriharim, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response