it could be due to a number of things, is there another error message printed in the output which gives a more specifc error message?

Have you checked the possible issues in the error message?

such as; make sure your parameters have variables associated with them and also check that the resultset is set properly...

SQL server is the best..

Edit the sql task and chane the resultset to singlerow under the general tab.

In the resultset tab add a new variable to hold the data that is being returned, make...

To do this you will need to use a resultset in your execute SQL task.

Edit the task and under the general tab change the resulset setting to the one...

You can't compare SQL Jobs to SSIS, they are two different products

You use SQL Agent to run Jobs that can include SSIS packages.

SQL agent and jobs are essential for Sql...

On your destination component, set the error output to send any errors to an error data flow.

Connect the error data flow to a flatfile or table and then run the...

Bulk Insert in SQL sever does not support quoted text, a better option would be to use the import/export wizard or SSIS to import the file as this will...

You can not access it directlty as it is set to no-recovery.

You could failover to the mirror and then look at it there , but since it...

The statistics may be out of date one server.

You cannot restore a single table.

You will need to restore to another db/server and copy the one table across.

You wont, this is why you should take backups regularly. Most places I have worked with take a Full each night and a t-log backup every 15...

From the backup taken in April..

I think you might be out-of-luck then. might not be a total loss as you could restore the data from April.

Sorry, I meant a recent backup that is not affected by the corruption.

I assume you run backups / checkdb on a regular basis?