I have a package that relies on looking up a certain column in a table from the warehouse. If this table is emptied for any reason, this will cause my package to fail as it cant retrieve the column. I want to be able to tell my package that if this table is empty then load the data from the table before it were emptied. How could I go about this? Any help would be great

in the lookup transformation editor set the "specify how to handle rows with no matching entries" as "redirect rows to no match output" and then connect no match output from lookup transform to an oledb destination to load whole data which is not match http://www.rad.pasfu.com