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 ?
It's possible. How? You need to spend some time understanding SSIS data flows, if you are less familiar with it.