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
Orlando Colamatteo
SSC Guru
Points: 182276
More actions
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