Looking to this great community for guidance.

I want to generate a SSIS Execute SQL task. I have the command to generate a table, but I'm having difficulty figuring out how to wrap this/include it in a SSIS command to check if a table exist.

I've seen things like "If Exists (Select * from MSysObject…) Begin Create Table…. End". However, I have not been able to get this to work. I tried then understanding the necessary syntax by creating the query in MS Access, but failed to get the If Exists or Begin/End working. I was unable to locate the correct syntax in my searches, so I'm hoping someone here has some strong Access knowledge.

Bonus Question: If I want to have an a SSIS task that checks if table exist, and check for value in order to dictate a path how would I do that (sort of like if not exist, or value > x continue else stop processing)

Thank You!!!

I didn't find the right solution from the Internet.
References
https://social.technet.microsoft.com/Forums/en-US/eb85dcc5-5f84-4091-9d5e-1a78075eebf1/ms-accesscreate-table-if-not-exist?forum=sqlintegrationservices
Teaser Trailer