Create Table if doesnt exist and insert otherwise truncate

[Anonymous]

My current process is below

tSyBaseInput -----> tConvertType ------> tMSSqlOutput

Currently my data is loading from one database to another, with a tconverttype inbetween.

The action on the output table is Truncate Table, and Insert Data.

I am trying to meet the additional criteria;

1. If Table(output) exists then truncate and insert (Currently working)

2. If Table(output) does not exist then Create Table and Insert

And lastly, if there schema for table(output) is different from the tConvert - Drop and Create Table and Insert. 

Can anyone point me in the right direction for this?

Thanks.

[fdenis · Accepted solution]

you can manage your db structure using system tables.
retrieve table ifo then chose to drop or not.