Use of stored procedure (with input Parameter) from OLE DB Source to load the Data in SSIS | Part 12

Use of stored procedure (with input Parameter) from OLE DB Source to load the Data in SSIS:
Requirement:
1) SQL Server Data Tools for Visual Studio 2015
or
SQL Server Data Tools or Visual Studio 2019

Steps need to follow:
1) Add data flow task in designer and double click on it.
2) Add data source OLEDB and destination OLEDB and configure it both with connection string.
3) And run the projects.

CREATE TABLE [tbl_emp_detail](
[empid] [int] NULL,
[emp_name] [nvarchar](255) NULL,
[emp_location] [nvarchar](255) NULL,
[salary] [float] NULL
) ON [PRIMARY]

select * from tbl_emp_detail


create procedure sp_getemp
@emp_name nvarchar(100) ,
@emp_location nvarchar(100)
as

After configure the both data source with ole db stored procedure and destination with connection string and table for which data will transferred. And run the application data will transferred successfully.

[hasanmougharbel]

Hey there, Great efforts in this channel.
I have learned recently about assemblies.
In what way, Assemblies are different from stored procedures?
I appreciate your help at your sole convenience.
Thanks a lot.