MrDavidThorn
asked on
first SSIS package using output variables
Hi
Experts I am migrating the below stored procedure to a SSIS package, Iv not used SSIS before and not sure how I can replicate the passing of variable as an output on a called sp and then use it later on, does anyone have any advice on how to do this or a quick guide
Experts I am migrating the below stored procedure to a SSIS package, Iv not used SSIS before and not sure how I can replicate the passing of variable as an output on a called sp and then use it later on, does anyone have any advice on how to do this or a quick guide
ALTER PROCEDURE [dbo].[spProcess_TRS]
AS
BEGIN
DECLARE @FromDate datetime --Used to store the date where event_time is proecssed FROM
DECLARE @ToDate Datetime --Used to store the date where event_time is proecssed TO
DECLARE @X int --Used to store the number of trades that have a report status of X
DECLARE @C int --Used to store the number of trades that have a report status of C
DECLARE @F int --Used to store the number of trades that have a report status of F
DECLARE @N int --Used to store the number of trades that have a report status of N
--Delete previous data
Delete from tblImport
Delete from tblTradeHistory
Delete from tblProcess
EXEC dbo.spProcess_Import @FromDate output, @ToDate output
PRINT N'IMPORT COMPLETE'
EXEC [dbo].[spProcess_Enrichment]
PRINT N'ENRICHMENT COMPLETE'
--Export the file
EXEC dbo.spCreate_TRS_File
PRINT N'TRS FILE EXPORTED'
EXEC dbo.spProcess_HistorySanpShot
PRINT N'HISTORY SNAPSHOT COMPLETE'
SET @X = (Select Count(Report_Status) from qryExport_All where Report_Status ='X')
SET @C = (Select Count(Report_Status) from qryExport_All where Report_Status ='C')
SET @F = (Select Count(Report_Status) from qryExport_All where Report_Status ='F')
SET @N = (Select Count(Report_Status) from qryExport_All where Report_Status ='N')
Insert Into tbllog (FromDate,ToDate,RunDate,X,C,F,N) Values
(
@FromDate,
@ToDate,
Getdate(),
isnull(@X,''),
isnull(@C,''),
isnull(@F,''),
isnull(@N,'')
)
PRINT N'COMPLETION OF PROCESS'
END
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
NP..
ASKER