I am new to SSIS.
I am trying to replace aaa.bat file call from SSIS package by Storedprocedure(batch file by StoredProcedure), I have written all the codes in Storedprocedure and its working fine. but i am just struggling to log the output to a text file.
In the Batch , some are sqlcmd statements so logs will be segregated to a single log. How do i get the logs same logs from execute SQL task in SSIS.