How to process a (txt) file through an exe within the same folder using ssis and then logging that it has completed?
Do I first create a .ps file that calls does the work example of code in ps file : [.\ file.exe file output.txt] And then call that .ps file using a bat file?
Or can this be done via ssis to run just the .ps file and upload a status on a sql table saying completed?