Use of stored procedure (with input Parameter) from OLE DB Source to load the Data in SSIS | Part 12
ฝัง
- เผยแพร่เมื่อ 9 ก.ย. 2024
- 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
select * from [dbo].[tbl_emp_detail] where emp_name=@emp_name and emp_location=@emp_location
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.
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.
Thanks for the info!