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

  • September 13, 2012 at 5:02 pm

    #1537575

    I thinks that I need a package that runs as a step in a job and if it finds the record in the table it executes the second step which would be an SSIS Load Package.

    If the second Step in the Job Completes the Job will not run again.

    Does this sound right or am I totally off base?

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/