In OLEDB editor, you may browse .sql file as command to use it as data source.
With Execute SQL Task in SSIS, you may select a text file or .sql file that contains an SQL Statement using a File Connection manager.
Why do you want to use .sql query file as a data source? As a text source or any other usage?
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.
Hot issues October