i want run this procedure in SSIS, so am running thru Execute task.
EXEC MIS_ETL_EXT_DATA '20120520' , 0 , '02-01-03' , 'DAILY'
here 20120519 is YYYYMMDD (yesterday date)
0 - static value 02-01-03 - Procedure ID Daily - Frequency
this job is Scheduled so how can i get date by default run
this is original procedure:
CREATE PROCEDURE dbo.MIS_ETL_EXT_DATA @pdtBUSINESS_DATE SMALLDATETIME, @pnTHREAD_D TINYINT, @psPROCEDURE_ID CHAR(8), @psFREQUENCY VARCHAR(7)
Submitted under: SSIS - SQL Server Integration Services · · · ·
Please follow Steps, u can get yesterday DATE:
in Execute SQL task:
DECLARE @pdtBUSINESSDATE SMALLDATETIME SET @pdtBUSINESSDATE=DATEADD(day,-1,GETDATE())
EXEC MISETLEXTDATA @pdtBUSINESS_DATE , 0 , '02-01-03' , 'DAILY'