We have SSIS/SSMS intalled on ServerA. We have a .bat file and an application and on ServerB. The application processes an input text file and produces an output file.
I can be flexible on how to do this, but we've been trying to get this to work with SSIS. We use SSIS for processing prior to producing this file and then we have to stop, manually run the application, then start with post processing in SSIS.
Once the file is exported to a folder, the next step in our package (hopefully) is to call a .bat file that runs a cmd line script that has the application process the file (in silent mode...not sure if that is unique to this app??). We had this working from the DataStage ETL tool, but DataStage and the bat file were on the same server as the application that does the processing. We aren't as fortunate now.
I've got many hours invested in this and I just can't get this to work. I've tried Execute process task, Powershell scripts. I don't know if it's syntax problems or simply logic problems. I'm stumped.
the name of the .bat file is: EXECUTE_GROUPER.bat which is located on E:\Batch_Files of ServerB
In the EXECUTE_GROUPER.bat file, just the one command to run the application: (Application is on C: on ServerB)
"C:\Program Files\Medical\Medical Grouper 2014\MedicalGrouper2014.exe" -silent
Any assistance is GREATLY appreciated.
..btw 2012 versions of SQL Server