Hi, Does anybody know how I can Produce a script or some function in SSIS that will check.. if Table1 has no data in it then load data from the backup table1? I want to put this at the start of the ETL... as it is failing if this table has no data in it.

There are several ways that you could perform this operation. For instance, you can use an execute sql task at the beginning of the package and return the row count into a variable. You can then use the variable as part of an expression on a precedence constraint leading into the data flow. (i.e. RowCount == 0). Hope this helps!Please mark answered posts. Thanks for your time.