Click here to Skip to main content
15,882,464 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
I have arequirement where I have to execute a java script with mql(matrix query language) get the output and store it in a table. So I'm trying to use the script source component within a data flow task but I'm stuck, can anybody help please
Dim strCommand As String
strCommand = "java -cp ""C:\enovia\studio\java\lib\eMatrixServletRMI.jar;C:\enovia\studio\java\lib\domain.jar;."" MQLBridge ""temp query bus Boat * * select current dump ~;"""
Dim startinfo As New System.Diagnostics.ProcessStartInfo
startinfo.Arguments = strCommand
'System.Diagnostics.ProcessStartInfo startInfo = new System.Diagnostics.ProcessStartInfo(Setting.PostProcessor,commandLineArgs);
startinfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal
startinfo.WorkingDirectory = "C:\enovia\studio\bin\winnt"
startinfo.UseShellExecute = False
Dim process As New System.Diagnostics.Process
process.StartInfo = startinfo
Dim obj As Object = process.Start("java.exe")
Updated 29-Jun-11 20:20pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900