I'm trying to read 100 numbers of tables from MSSQL which having different schema.
And create accessDb files .accdb from that.
Is any one know how we can read all this tables dynamic?
If you are using enterprise edition u can find option as dynamic schema .By using it u can complete your job
Thanks for the reply,
But in the tAccessDBOutput, I'm getting that component does not support dynamic schema.
Is nay another method to write accessdb file from the dynamic data type.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema