Execute Process From Script Component Transform

In my data flow, I am reading addresses from a CSV file. Then for each row, I would like to execute a process from the command line which outputs the latitude and longitude for the address, parse the output, and add the latitude and longitude into the pipeline. To call the process, I am using a script component transform. Here's my code:


Dim m_Latitude As Double

Dim m_Longitude As Double


Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)


Dim street As String

Dim city As String

Dim state As String

Dim zip As String


street = Row.address

city = Row.city

state = Row.state

zip = Row.zip


Dim p As Process = New Process()


p.StartInfo.FileName = "C:\GeoCodeDotNet.exe"

p.StartInfo.Arguments = String.Format("""{0}"" ""{1}"" ""{2}"" ""{3}""", street, city, state, zip)

p.StartInfo.WorkingDirectory = "C:\"

p.StartInfo.UseShellExecute = False

p.StartInfo.CreateNoWindow = True

p.StartInfo.RedirectStandardOutput = True


AddHandler p.OutputDataReceived, New DataReceivedEventHandler(AddressOf ConsoleDataReceived)


p.Start()

p.BeginOutputReadLine()


If p.WaitForExit(10 * 1000) Then


Row.Latitude = m_Latitude

Row.Longitude = m_Longitude

Else


p.Kill()

Row.Latitude = 0.0

Row.Longitude = 0.0

End If

End Sub


Private Sub ConsoleDataReceived(ByVal sender As Object, ByVal e As DataReceivedEventArgs)


Dim output As String() = e.Data.Split(New [Char]() {" "c})

m_Latitude = CDbl(output(0))

m_Longitude = CDbl(output(1))

End Sub


I'm just getting very weird behavior. First of all, at the point where I assign values to Row.Latitude and Row.Longitude, m_Latitude and m_Longitude don't always have valid values (e.g. - they are unassigned). Secondly, after attempting to process the first couple rows, it just stops. In my data flow, the script component is yellow, but execution has ended, and the final step of writing to the output CSV file has not even started. Finally, in the directory where my source CSV file is located, I get a SQL dump file with the following content:

05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 5480
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0100C5D0
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
05/09/08 08:40:00, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL Server90SharedErrorDumpsSQLDmpr0016.mdmp
05/09/08 08:40:00, ACTION, DtsDebugHost.exe, Watson Invoke: No


I'm guessing this all has to do with some kind of threading/concurrency thing and how the data flow pipeline works. Could someone please shed some light on this?

By the way, the script component transform is synchronous.
Much thanks.