The whole query will not fetch any rows.

Because the table is dropped at the end.

I got the solution for this.

I set the property Delay Validation as TRUE for all Data flow tasks.

So my package is failing only during runtime .i,e., it is failing only...