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 20, 2012 at 1:16 pm

    #1540339

    btw,

    Before I check for the records in a table I also will have two packages and both check for the existence of a file in two separate folders.

    Currently this logic is in a C# exe and is run via the task scheduler but I want to incorporate it into SSIS so that I have full control.

    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/