Hi,

I have 10 .txt files in a directory and I want loop through the
directory dynamically creating a table in SQL for each .txt file. Each
text file has a different column list that's why it has to be
dynamic.

Thanks in advance,

Tom

Hello T,


OK so the looping is easy.

The next thing you will need to do is to look at the text file and have a
way od deciding what the attribute data types will be. Once you have this
then you can build a CREATE TABLE script against your destination. You execute
that. Now you have a DataPump task that you set the DestinationObjectName
property to be that of the table you just created.

You now need to build the Transformations from scratch but luckily this can
be done programmatically as well.


Make sense

Allan