Agreed!

However, this gives us all the tables. Not a problem.

My next question is, can this task be automated via a SSIS ?

What I mean is can I have a job that runs everyday at 6 PM and have the definitions file being written to

some directory ?