ODBC Source - Browse file for SQL - Dynamic

Question

Hi All,
In a ODBC source we have option to pass the query from file (Browse option) which static .But i want to make dynamic.
Meaning i want to generate a file every day with time stamp and use that exact file with time stamp as passing query into ODBC source.
Attached the snapshot plz check.

Hope you understand my question.

Answer 1

Hi @Gopinath Desai ,

1.Please check the file directory in your ODBC data source;
2.Use Foreach Loop Container to foreach files in the directory;
3.Drag a Data Flow Task in Foreach Loop and then drag ODBC source in DFT.
4.Specify expression for ODBC Sql Command in the properties of DFT.

Please refer to the following pictures:

Best Regards,
Mona

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. 7: https://learn.microsoft.com/en-us/answers/articles/67444/email-notifications.html