Home Forums Data Warehousing Integration Services how to pass variable to oledb source RE: how to pass variable to oledb source

  • December 20, 2013 at 3:31 am

    #1675083

    Nomvula (12/20/2013)

    hi guys

    i've created sql task with the following query 'SELECT MAX(wwo.StatusChangedOn) AS MaxDate

    FROM wrkWorkOrders AS wwo where wwo.Description = 'Completed Costing' and set up Result Set: Result Name = MaxDate, Variable Name = User::MaxDate.

    i want to join Data flow task add and on the oledb source write a select statement to select * from wrkWorkOrders where StatusChangeOn <= MAX(wwo.StatusChangedOn) from the result set.

    please help

    Why not write this as a single query in an OLEDB Source component? Are your data sources different?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.