|
ismailc
Constraint Violating Yak Guru
South Africa
275 Posts |
 Posted - 08/06/2007 : 06:22:58
|
Hi, This is my first SQL Task using parameters. OLE DB
How do I define in my SQL TASK1
SELECT Run_Period, Run_DateFrom, Run_DateTo FROM dbo.MIS_System_Parameters WHERE Run_Type = 'SELECTED'
1. run_period (decimal) as parameter 0 2. Run_DateFrom (integer) as parameter 1 3. Run_DateTo (Integer) as parameter 2
To be used in my second SQL TASK2 and defined in second task as well.
Delete from MIS_Customer_Documents where Doc_Period=?
Please anyone with assistance!
Regards
|
|
Create Param from SQL Task1 parse to SQL Task2
