Using Stored Procedures to load data

Here is an example of how to load data using a stored procedure.

Using this approach gives the user the ability to perform complex transformations inside the database, for example, the user may have a look table that is just too big to pull out or a user may want to reuse existing code.

Table Creation Script

CREATE TABLE [dbo].[orders](
[customerid] [char](5) NOT NULL,
[orderno] [decimal](20, 5) NOT NULL,
[orderdate] [smalldatetime] NOT NULL,
[amount] [decimal](16, 2) NOT NULL

Stored Procedure Script

CREATE PROCEDURE [dbo].[p-Populate-Data]
@customerid char(5),
@orderno decimal(20,5),
@orderdate smalldatetime,
@amount decimal(16, 2)
set nocount on
insert into orders (customerid,orderno,orderdate,amount)


Stored procedure

Stored procedure

Stored procedure

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: March 14, 2023