154 How to export data to multiple excel files in SSIS

[@TenhoDados]

Congrats, your explanation is incredible!

[@TenhoDados]

One detail. The video file is not in the google drive folder. Last one is 153.

[@ManojKumar-zn2gf]

Hello Aqil, thank you so much! The video was really helpful. I have a question: I have a SQL Server and an Excel workbook stored on SharePoint. I want to upsert data from the SQL Server into the Excel workbook using SSIS, but without downloading the file to my local machine. Is this possible to achieve?

[@learnssis]

No, this is not possible from SSIS.

[@ManojKumar-zn2gf]

Do you mean we can't update an Excel workbook in SharePoint online using SSIS? Could you give me an idea of how to proceed? Thanks in advance!

[@learnssis]

@@ManojKumar-zn2gf We can't update an excel workbook in sharepoint without downloading it. We don't have any task in SSIS to download the excel workbook from sharepoint. You would need to write code in C# to do that or maybe need to use third party ssis component to download the file from sharepoint kzbin.info/www/bejne/ZmnEgaR8rNSoldE

[@Marina1BEL]

thanks for all your explanations

[@learnssis]

You are most welcome Marina.

[@sagar8008]

Nice Explanation...🤝

[@learnssis]

Thank you Sagar.

[@sagar8008]

Can you provide any Material for SSIS?

[@learnssis]

@@sagar8008 email me at [e-mail], I can share the pdf book for SSIS.

[@tejaskurle5954]

Hi I want to alter the table by adding column with Boolean value in MySQL, but Boolean is not supported tinyint is also not supported. What can we use

[@learnssis]

We have a bit data type that you can use. alter table demo add Active bit

[@neelamkushwah1079]

Sir how can connectto you because in real time i am facing issues and one team member in gurgaon and another on in Chennai and iam in pune so very hard to take help.