filmov
tv
Use stored procedure (without any Parameter) from OLE DB Source to load the Data in SSIS | Part 11
Показать описание
Use of stored procedure (without any 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_employee](
[empid] [int] IDENTITY(1,1) NOT NULL,
[emp_name] [nvarchar](150) NULL,
CONSTRAINT [pk_empid] PRIMARY KEY CLUSTERED
(
[empid] ASC
)
)
select * from tbl_employee
use of SP:
create procedure sp_emp_detail
as
select * from tbl_employee
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_employee](
[empid] [int] IDENTITY(1,1) NOT NULL,
[emp_name] [nvarchar](150) NULL,
CONSTRAINT [pk_empid] PRIMARY KEY CLUSTERED
(
[empid] ASC
)
)
select * from tbl_employee
use of SP:
create procedure sp_emp_detail
as
select * from tbl_employee