Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Versions des environnements
SQL Server:
SQL Server 2012
>>>>
>>>>This is occurring in a Foreach loop container.
>>>>
>>>>I juts tried a test in a small dtsx of a simple sql statement that fails and the right route is taken.
>>>>But when that is in the foreach it fails the package even though FailPackageOnFailure is F.
>>>>
>>>>Nick
>>>
>>>OK....what kind of foreach loop? (..for each file, for each ADO record, etc.....)
>>
>>A file foreach
>>
>>But I found a tip to set maximumerror count to 0 and then my test works but unfortunately the actual package I'm working on still doesn't :-(
>
>Is your error routine/error path "inside" the foreach loop or outside?
There is an error event handler for the package but not for the the sql step . Its an SSIS template somewhat larger than I'm used to used by the people I'm working with at the moment.
SO the SQL step that I've added is in a for each loop which is in a container which is in a container .
I've just tried adding passing out a parameter from the step and a conditional contraint based on that but that gets ignored as well. And I've temporarily deleted the package error event handler as well.
And still no go.
Maybe I should handle any error in the sql so it never fails and pass out my own error result.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement