""Peter YangMSFT]"" wrote:

> Hello Jason,
>
> I understand that you'd likek to know if you could save variable to
> checkpoint file so that it could be reused when restarting the package. If
> I'm off-base, please let me know.
>
> This feature is not support and there is no option to support to write
> variables to a checkpoint file. To work around the issue, you may need to
> creating an OnError event handler for tasks that FailPackageOnFailure is
> true to save the variables to a table or file. In the tasks you may need to
> check the table/file to see if you need to update the variables.
>
> If you have any comments, please let's know. Thank you.
>
> Best Regards,
>
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Community Support
> ==================================================
> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications
> <http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> <http://msdn.microsoft.com/subscriptions/support/default.aspx>.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>