Check table before Import

[girky]

Hello!
I have a package that deletes all the data in a table then imports new data from access. I want to first check to see if the access table has data in it before deleting the old data. Is there a way to do this?
Thanks in advance!

 

[tb]

How would you normally check?

Where are you doing the data transfer?
* SQL task
* ActiveX Script Task



I was standing in the park, wondering why frisbees got bigger as they came closer... then it hit me!