question

ajayrawat-5337 avatar image
0 Votes"
ajayrawat-5337 asked Monalv-msft commented

Logging is not working while running SSIS package from Batch file

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

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Monalv-msft avatar image
0 Votes"
Monalv-msft answered

Hi @ajayrawat-5337 ,

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

88018-editssislog1.png
88105-editssislog2.png
88106-batchfile.png
88164-executepacakgewithbatch.png
88157-ssisloginssms.png


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.




editssislog1.png (14.2 KiB)
editssislog2.png (16.2 KiB)
batchfile.png (10.4 KiB)
ssisloginssms.png (92.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ajayrawat-5337 avatar image
0 Votes"
ajayrawat-5337 answered Monalv-msft commented

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/

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ajayrawat-5337 ,

Please remember to accept the answer that resolved your issue.

This can be beneficial to other community members reading this thread.

Best regards,
Mona

0 Votes 0 ·
ajayrawat-5337 avatar image
0 Votes"
ajayrawat-5337 answered ajayrawat-5337 edited

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


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.