Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Package failure
Message
From
16/05/2012 06:29:02
 
General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Title:
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01543285
Message ID:
01543661
Views:
29
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
Previous
Reply
Map
View

Click here to load this message in the networking platform