Great idea but YOU are not the one to determine what is on track and what is not especially since you only provided pseudo-code to someone who may not know the language base (if he did, he'd have written it already).

@sql_enthusiast,

If you don't know enough about the scripting language that Orlando (opc.three on this thread) used to complete it, the example working code I gave will work and I believe you can execute it as an SQL Task (don't know the official name of the task, though). As has been identified, it does use an undocumented stored procedure that could become unsupported at any time. Before you let that shake you, remember that it is still available in all current versions of SQL Server from at least 2005 through 2012. Also remember that something doesn't have to be documented to be quickly removed or change shape. For example, sp_MakeWebTask was very well documented and supported and it went away virtually overnight because Microsoft thought everyone would go ga-ga over SSRS :sick:.

I am in no way trying to force such code on you (besides, I've seen you in action and know that couldn't happen if I tried). I am, however, trying to give you options. Before you had none. Now you have at least 3. If you know enough to complete Orlando's pseudo-code, that would certainly be a good way to go when using SSIS (I still can't believe that something like that wouldn't be included in an ETL tool, though).