Jeff, each SSIS task allows for a dual chain of events to be processed from the task; 1 Path for success/completion/expression test, 2 Path for failure.

It seems like this is...

If the job works once, you know there's nothing wrong with the statement, connection etc.

I'm a novice at Oracle, but could it have something to do with table/record locks, or...

Arrgh.  The issue resulted from a semaphore timeout in the connection to a network path on a file server.

After doing a lot of data stripping and testing I still experienced the problem at...

There should be a Maximum Error Count property you could increase for the package, for/each loop and the data flow.  I know packages fail when this limit is hit, which is...

I don't think the actual lock can be detected, but how about the lock's trail?

When an Access db is open (xxx.MDB) a locking file (xxx.LDB) is created right beside it. ...

This is good stuff!  I've just started digesting this as well as your other post referencing data driven subscriptions.

I just can't wait to do some damage with this!

Thanks!

-r

Thanks!  That helps alot! 

I was thinking the use of a data flow was the way to go, but this looks more direct.  I'll play around and let you know...

Yes!  I've been working on a very complex GROUP BY query breaking down timestamps into variable hourly groupings. (1 hour, 2 hours, 3 hours etc.)  I've had to copy this...

Thanks, John!  I feel much more confident after hearing your comment!

-r.

Thanks for your advice!  I don't know if i used the NORECOVERY option.  I was able to drop the database and recreate then restore it from a good backup file.

Thanks for the input!  I'll be sure to check out the website and implement your suggestions!

Thanks for your counsel!  I appreciate the suggestions!

To be fair, management isn't expecting it to be done immediately, and sometimes the best way to learn is to jump right in. ...

Try doing a google search for "XML CData definition" or "XML PCData definition".  You should get a number of hits to get you started.

Thanks Eric, Ron for your replies.

I think the firewall is my issue.  I'll look into it with the network guys.

I can gather csv files from the site, so i know the ftp task works. It is just having an issue with .zip files.

I'm going to try some activex code...