Logging is not working while running SSIS package from Batch file

Question

Hi Everyone,

I created an SSIS package and in that, I used SSIS Logging (SSIS Log Provider for SQl Server) created a log table in the SQL database.
When I am running the package from BIDS everything is getting logged properly in the Logging table.
Problem is coming when I am running the package from batch file nothing is getting logged in Table.
Can anyone help me out why this is happening?

Thanks

Answer 1

Hi @ajay rawat ,

1.Could you please share the screenshots about your setting the SSIS logging in package?

2.Please check if you write the batch file successfully.

@ECHO OFF  
CLS  
ECHO You are about to execute the TestPackage SSIS package  
PAUSE  
"C:\Program Files\Microsoft SQL Server\140\DTS\Binn\DTEXEC.exe" /File "C:\Mona\SSIS\2021\4Apr\Pro\Integration Services Project3\Package.dtsx"  
PAUSE  

3.Hope the following link and pictures will be helpful:
How to execute an SSIS package from the command line or a batch file

Best regards,
Mona

---

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.

Answer 2

Hi Mona,

Thanks for explaining so briefly.
I am also doing the same steps.
Logging is running fine when i am running it from BIDS.
When i am running it from below batch script nothing is getting logged.

This is my batch script content

@Echo OFF
CLS
ECHO You are about to execute the TestPackage SSIS package
PAUSE
"C:\Program Files\Microsoft SQL Server\150\DTS\Binn\DTExec.exe" /File "C:\Workspace\DataMigration\SSISDataMigration\DataMigration.dtsx" /CONFIGFILE "C:\Workspace\PackageDeployment\Config.dtsConfig"
PAUSE

Answer 3

Thanks for help, Issue got resolved by installing SSIS services.
Below is the Link that helped me .
https://www.mssqltips.com/sqlservertip/6635/install-ssis/