154 How to export data to multiple excel files in SSIS

How to export data to multiple excel files in SSIS
SSIS Tutorials: • SSIS Tutorials
SSIS real time scenarios examples: • SSIS real time scenari...
SSIS Interview questions and answers: • SSIS Interview questio...
06 Download and restore adventureworks database to SQL Server 2019: • 06 Download and restor...
How to export data to multiple excel files in SSIS
How do you export data to multiple Excel sheets?
How do I export data from SSIS package to Excel?
How do I output SSIS to a new Excel file?
Happy Learning.
If you have any questions or suggestions please comment on the video or write to me at “[e-mail]”

[@TenhoDados]

Congrats, your explanation is incredible!

[@TenhoDados]

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

[@deepreview]

Hi, I have a scenario where I have built a dynamic query in Sql server. In the query, the column header changes every month, giving only the past 1 year of data. The same data I want to copy into Excel. Can I do it in SSIS? Pls note that I need to build the mapping one time, and every month, the report will be generated at a given path.

[@learnssis]

If header changes then you would need to write some C# code to export it. SSIS data flow task won't be able to do it.

[@deepreview]

@learnssis Thanks a lot for replying. Can you suggest some page or video. I am not too familiar with C#

[@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

[@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.

[@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.

[@Marina1BEL]

thanks for all your explanations

[@learnssis]

You are most welcome Marina.