General information
Forum:
Microsoft SQL Server
Category:
Business Intelligence
Environment versions
SQL Server:
SQL Server 2008
HI
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only