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?
@@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 ua-cam.com/video/08aPqFwou_o/v-deo.html
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.
Congrats, your explanation is incredible!
One detail. The video file is not in the google drive folder. Last one is 153.
thanks for all your explanations
You are most welcome Marina.
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?
No, this is not possible from SSIS.
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!
@@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
ua-cam.com/video/08aPqFwou_o/v-deo.html
Nice Explanation...🤝
Thank you Sagar.
Can you provide any Material for SSIS?
@@sagar8008 email me at aqil33@gmail.com, I can share the pdf book for SSIS.
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
We have a bit data type that you can use.
alter table demo
add Active bit
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.