capturing errors for failed file transfers

Advertisement

gardenburger
Joined:
Posts:
1
Location:
Kansas, USA

capturing errors for failed file transfers

I see how there is an example provided to log the Success of transferred files

For Each transfer As TransferEventArgs In transferResult.Transfers
   Dts.Events.FireInformation(0, Nothing, String.Format("Upload of {0} succeeded", transfer.FileName), Nothing, 0, fireAgain)
Next    

but I haven't found any examples of how to log, or capture, Failed file transfers.

I notice there is a .Failures in TransferEventArgs and I suspect that somehow we can loop through and get error messages and other info about failed transfers.

Maybe something like this?:

For Each xtransfer As TransferEventArgs In transferResult.Failures
    Dim vErrMsg As String = xtransfer.Error.Message.ToString()
    Dts.Events.FireInformation(0, Nothing, String.Format("Upload failed: {0}", vErrMsg), Nothing, 0, fireAgain)
Next    

I see that intellisense lists the following interested items under .Error such as:

.Data
.HelpLink
.InnerException
.Message
.Session
.Source
.StackTrace
.TargetSite

I am not sure which of these are WinSCP specific intended for logging errors and reporting file transfer failures.

I am using this in an SSIS VB.NET Script Task
Any help or examples with capturing errors would be greatly appreciated.

Reply with quote

Advertisement

You can post new topics in this forum