Conditionally Creating a New Table
I have a job that compares a master table with a stage table every day, compares changes, and then does an incremental load of any new or changed records. This all works fine, EXCEPT the very first time the project is run, since the Master table does not exist yet. Is there any combinations of components or someway to only create the master table if the table does not exist already? This way, the master table will get created the first time the job runs (since it doesnt already exist)...but then on subsequent runs, the master table will not get created again (since it already exists) and will just have the data since the last run. Any way to do this?