I have a DTS package that copies a table from one server to several other databases on other servers. I want to add an "Execute SQL Task" to it that does this:
SELECT COUNT(*)
FROM table
AS @count
IF (@count) > 0
<return success so that the package continues>
The idea is that if the table is empty, it won't be copied. How do I do this so that the ON SUCCESS workflow works?
SELECT COUNT(*)
FROM table
AS @count
IF (@count) > 0
<return success so that the package continues>
The idea is that if the table is empty, it won't be copied. How do I do this so that the ON SUCCESS workflow works?