Forum Discussion

Zhiming_12's avatar
Zhiming_12
New Member
2 years ago

SSIS package in visual studio 2019

I created a SSIS package in the visual studio 2019 with a script task in using visual basic 2019 code to write a message to a text file.

the script task function well in my local computer but set a job to run the package in a server, the script task didn't work. can some one help to solve the issue?

 

Thanks,

Julie

4 Replies

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee

    Hi Zhiming_12 

     

    Thanks for using Microsoft Fabric Community.

    Could you please share some more details like, screenshots of the issue that you are facing and where are you creating the job? This will help me to understanding your query in detailed and guide you in better way.

     

    Thank you.

    • Zhiming_12's avatar
      Zhiming_12
      New Member

      Thank you v-cboorla-msft!

      I am a developer to do SSIS package. A job is setting by a SQL server administrator in SQL server management 2019.

      I have no idea how he set up the job. He sent to me the screen shot after ran the job.

       

       

      My C# code here, just want to write a message to a log file  in a script task, it works well in my local but not in server job.

       

      • v-cboorla-msft's avatar
        v-cboorla-msft
        Microsoft Employee

        Hi Zhiming_12 

         

        Apologies for the inconvenience and delay in response.

        Please reach out to our support team to gain deeper insights and explore potential solutions. It's highly recommended that you reach out to our support team. Their expertise will be invaluable in suggesting the most appropriate approach.

        Please go ahead and raise a support ticket to reach our support team:

        https://support.fabric.microsoft.com/support

        After creating a Support ticket please provide the ticket number as it would help us to track for more information.

         

        Thank you.