SQL Server Performance

Create Parameters from SQL Task1(OLE DB) then use result as a parameter in SQL Task2 - How?

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Aug 6, 2007.

  1. Ismailc New Member

    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 3
    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
  2. satya Moderator

    Not clear where you want to perform this action?
  3. Ismailc New Member

    Hi, I want to perform it in the control flow.
    Where my SQL Task1 is like DTS 2000 set Global variables and then the execution of the SQL Task1 set them as Output Parameters (Row value)
    then for me to use them in other SQL task as input parameters.
    Thank You for the assistance.
    Regards,
  4. Ismailc New Member

    Hi My mistake, i had to create global variables in order for the other task to recognise it.

Share This Page