SSIS Tutorial 06- Update and Delete the Data from Excel to SQL Server in SSIS.

Hello Everyone, Today we will learn, How we can Update or Delete the data from Excel to SQL Server in SSIS.

We will cover following Topics:
  • ✔ How to Update the data from Excel to SQL Server in SSIS.
  • ✔ How to Delete the data from Excel to SQL Server in SSIS. 



SSIS Tutorial 05- Create Our First SSIS Basic Package | Migrate Data from Excel to SQL Server.

Hello Everyone, Today we will learn, How we can migrate the data from excel to SQL Server.

We will cover following Topics:
  • ✔ How to create a package in SSIS.
  • ✔ How to Migrate the data from Excel to SQL Server (Create Operation).
  • ✔ How to Create a Connection with SQL Server / Excel in SSIS.



SSIS Tutorial 04- Basic Components of SSIS | SSIS Toolbox, Control Flow, Data Flow etc.

Hello Everyone, Today we will learn about some basic Components of SSIS like SSIS Toolbox, Control Flow, Data Flow, Connection Manager. Before creating any package, It is very important to understand about these components.

Today we will cover following Topics:
  • ✔ What is Control flow and Data flow.
  • ✔ What is SSIS Toolbox and How to open SSIS Toolbox.
  • ✔ How to Use Connection Manager.



SSIS Tutorial 03- Environment Setup for SSIS in VS19

Hello Everyone, Today we will learn about Environment Setup for SSIS (SQL Server Integration Services) in Visual Studio 2019 version.


SSIS Tutorial 02- What is SSIS | What is ETL Process

Hello Everyone, Today we will learn about SSIS (SQL Server Integration Services), ETL process, What is the use of SSIS.

We will cover following Topics:
  • ✔ What is SSIS and ETL Process.
  • ✔ Use of SSIS


SSIS Tutorial 01- Welcome to new SSIS course

Hello Everyone, Welcome to our new SSIS (SQL Server Integration Services) Course series. 


Rename the text "Redeem Invitation", "Register", "Sign In", "Redeeming Code", "Sign Out" in PowerApps Portal/ D365 Portal

Hello folks, In the today's article, we are going to learn about some hidden content snippets or we will learn how we can rename the some text in PowerApps Portal/D365 Portal.

Let's rename some below text on portal:

  • "Redeem Invitation" to "OTP".
  • "Register" to "Sign-up"
  • "Sign In" to "Log-in"
  • "Redeeming Code" to "OTP"
  • "Sign Out" to "Log Out"


Render Party list field on Entity List's Activity view (Email or Portal Comment view) in PowerApps Portal (D365 Portal).

Hello folks, In the today's article we will learn, 

⇒ How we can render the Party List type field on PowerApps Portal (D365 Portal). 

Sometime we could have a requirement to apply the the Activity view on portal and activity could be of any type like Email/Portal Comment/Task/Appointment etc. Some of these entity contain Party List type field like in Email or in Portal Comment, To and From field is Party List. When we apply the view of entities which contain the party list field, the data in these fields won't render properly. it would comes like this as in below snapshot.