I have created scores of packages for importing files into my database. In order to make this easier to manage I've created a package with a matching import for each file I want to import. Then I've created projects with logical groupings of import packages being run in sequence. Finally, I have a driver package which calls each of the group packages in turn. In addition I have an ftp package which gets all of the files I intend to import. My driver package's starting point is my ftp package.
This morning I encountered an error in my ftp module and with the ftp package the error handling within the package was invoked. However, in my driver package it continued on with routine processing, attempting to import all of the files even though I had been unsuccessful at downloading any data files.
Is there a way to indicate that when a package completes its processing via an object (the final object invoked in the package when an error is encountered within the package) that the package should return an error so that a calling package can recognize that an error has occurred? Do I need to incorporate my ftp object within the driver package in order to capture this error condition instead of including a package which invokes the ftp package?
