Hi anonymous user-9275,

May I know if you have anything to update?

Best Regards,
Mona

Hi ZELALEM,

May I know if you have anything to update?

Best Regards,
Mona

Hi @RajD-9527 ,

May I know if you try the solution above?

Please don't hesitate to contact us if you have anything to update.

Best Regards,
Mona

Hi @ashish2021-8276 ,

Please check if you install the SQL Server Data Tools (SSDT) for Visual Studio correctly.

Hope the following links will be helpful:
1.Download SQL Server Data Tools (SSDT) for Visual Studio
2.Installing SSDT and creating your first SSIS Package

Best regards,
Mona

Hi @WojciechBukowski-4377 ,

May I know if you set any parameter in your ssis package?

Please check if you set the ssis package correctly in Azure Data Factory pipeline.

We can refer to Run an SSIS package with the Execute SSIS Package activity in Azure Data Factory.

Best regards,
Mona

Hi @bukkybu-3222 ,

We can use OLEDB Source and Excel Destination to export data from SQL Server to Excel in ssis package.

It seems that we cannot export the data to excel with the html formatting and need to make sure the excel column word wraps on </br> and/or <p> tags in ssis package.

Please share us if you find the solution in other forums. Thank you.

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.

Hi @bukkybu-3222 ,

May I know if you have anything to update?

Best Regards,
Mona

Hi @COZYROC-9090 ,

May I know if you can use the new account to post or access the message?

Best regards,
Mona

Hi @Aviskumar-1057 ,

Please check if you set the namespaces correctly.

 #region Namespaces
 using System;
 using System.Data;
 using Microsoft.SqlServer.Dts.Runtime;
 using System.Windows.Forms;
 using System.Net;
 #endregion

Best regards,
Mona

Hi @LuisSimoes-5154 ,

Hope the following link will be helpful:

How to set cookie in browser using restharp?

Best regards,
Mona

Hi @LuisSimoes-5154 ,

Please use Try catch / Error Handling in the Script Task to get more error messages.

Hope the following link will be helpful:
Script Task Debugging in SQL Server Integration Services (SSIS)

Best regards,
Mona

Hi @LuisSimoes-5154 ,

Please share the example code in the attachment.

Best regards,
Mona

Hi @EFLin-4569 ,

However, the only issue I have is the tool will stuck in the Logger Mode if I stop the CDC Service for a period of time (like an hour).

Could you please tell us the reason that you stop the CDC Service for a period of time?

Best regards,
Mona

Hi @elinzeyjr-7790 ,

May I know if you have anything to update?

Best regards,
Mona

Hi @SunithaSingirikonda-7588 ,

May I know if you have anything to update?

Best regards,
Mona