Home Forums Data Warehousing Integration Services SSIS Job needs to run every 15 minutes for 8 hours to check for existance of a record in a Table for the Current Date RE: SSIS Job needs to run every 15 minutes for 8 hours to check for existance of a record in a Table for the Current Date

  • August 29, 2014 at 9:05 pm

    #1742041

    In the case of Oracle being the target I would go with option 2 and avoid introducing the use of OPENQUERY.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato