It does not give error. It executes.

Thanks Megha.

SELECT would results many thousand rows.

You have re-written the same query with alias, otherwise there is no difference between my query and yours right?

Thanks Gail.

Gail, you are absolutely right.

I have doing a batch delete due to large size of the table. But in case if I get error during delete, how do I capture?

If...

Then, how do we track the errors?

since table is very large, I cannot remove batch delete process.

I wanted some mechanism to track tables successfully deleted and failed.

Thanks,

Naveen J V

SP is also fine, but again SP needs to be called for each table right?

and transaction should be handled with in SP or what?

Rollback only table 30 and loop should continue from 31 onwards

Hi,

I am facing similar issues. Need to export from SQL table to pre-formated excel sheet.

can u please help me by sending the steps. I am a newbie to SSIS.

Thanks in...