Hi @Parihar, Rishi S,
Welcome to Microsoft Q&A!
You can use the Visual Studio Community 2022 with SQL Server Data Tools (SSDT) installed to design SSIS package.
Then, deploy and run packages in Azure.
For more information, please visit Deploy and run packages in Azure.
If you are facing script task compilation error in ADF, please start a new question so that we can better solve your problem. Thanks for your understanding.
Sincerely,
Anna
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 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.