Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Public Class ScriptMain
 Inherits UserComponent
 Public GetFilePath As String = ""
 Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
 GetFilePath = "C:\Rapagator\Downloaded" + Row.FileName
 End Sub
 Public Overrides Sub PostExecute()
 Variables.FilePath = GetFilePath
 MyBase.PostExecute()
 End Sub
End Class
How do you know the variable value is only the filename part you state? You cannot debug inside the Script Component, so perhaps add a MessageBox or log an event to write out the values you have just to be sure. Perhaps set a breakpoint as well and add the variable to the watch window. You do know that the Variables window only shows design-time values during runtime, even when completed or stopped on a breakpoint. Use the watch window to get real values. This does seem rather strange, are you only expecting one row to flow through this component; otherwise you will only store the last row's value in the variable. Is that what you want?
Does the filename start with a "\" ? If not the path looks invalid - C:\Rapagator\DownloadedMYFILE. Top tip, use System.IO.Path.Combine(x, y) as that will sort out path qualifiers for you.
 
No comments:
Post a Comment