Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Package failure
Message
De
16/05/2012 06:29:02
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Business Intelligence
Titre:
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01543285
Message ID:
01543661
Vues:
30
Hi Sergey

I didn't have handling for them.
I've resolved the problem that was causing the error by using a foreach FTP control from here

http://microsoft-ssis.blogspot.co.uk/2012/01/custom-ssis-component-foreach-ftp-file.html


>Did you add handling for those steps failures?
>
>>
>>I've created a data flow package running in SQL2008.
>>
>>The package starts with an FTP step and then a step to delete files from the FTP server which have been successfully downloaded.
>>
>>Subsequent steps process the data and finally archive the processed file.
>>
>>I don't want the package to fail when there is an error in the FTP step or the deletion of files from the FTP server.
>>
>>I've set these steps to failpackageonfailure = False and failparentonfailure = False but the package still fails if there is an error in these steps. is there anything else I should set for this ?
>>
>>Thanks
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform