ADF - Execute SSIS Package Task : Logging Issue

Thejaswini PM 1 Reputation point
2022-04-13T07:04:55.63+00:00

Hi ,

We are able to execute SSIS Package 'P1' using Execute SSIS Task in Azure Data Factory successfully and it is creating logs in the specified file share folder.
Please refer the below ss for the configured settings.

192565-image.png

 But If we provide a logging path as dynamic content(using variables or parameters or some strings), it's not creating any logs under the file share and also the logging level information(below part of code) is getting disappeared in the Pipeline Json file(but not showing any error).  

                "loggingLevel": "Basic",  
                "logLocation": {  
                    "logPath": @pipeline().globalParameters.FS_ConnectionString,  
                    "type": "File",  
                    "typeProperties": {  
                        "accessCredential": {  
                            "domain": "Azure",  
                            "userName": "test",  
                            "password": {  
                                "type": "SecureString",  
                                "value": "*******"  
                            }  
                        }  
                    }  
                }  

Please refer to the below ss where we are using variables to set the value of the logging path.

Please help.

Thanks,
Thejaswini

192530-image.png

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
{count} votes

1 answer

Sort by: Most helpful
  1. HimanshuSinha 19,527 Reputation points Microsoft Employee Moderator
    2022-06-02T19:33:59.433+00:00

    Hello @Thejaswini PM ,
    I am sharing the details from the ticket for the benefit of the community .

    On reviewing the ticket , it was identied as it needed a code fix which ADF has identified and will roll out a fix soon .

    Thanks
    Himanshu


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.