Create a script file Assuming you've installed the AdventureWorks2022 sample database, follow the example in this section to create a script file that you can run from the command prompt with sqlcmd.

place any queries you want to run in the queries.ps1 file ensure you enabled script sources for the collector in user.properties create a sumologic script source that executes the powershell script on ...

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.