Executing a VB Script file from VB.net

[J. Kingsley]

I am loading XML data into a SQL Server database using SQLXML with bulkload. I use a VB script file to perorm the load with the map schemas and the XML files. To do the load manually, you just double click on the VB script file which lies in a directory on the hard drive. Now I want to execute this file from a VB application or a Windows service. How do I call, reference or execute the file from VB.net?

[David Williams , VB.NET MVP]

You should be able to use Process.Start("SQL.VBS") [Where you replace
"SQL.VBS" with your named .vbs file] to run the script file.

HTH

David

"J. Kingsley" <JK*******@discussions.microsoft.com> wrote in message
news:2D**********************************@microsof t.com:

I am loading XML data into a SQL Server database using SQLXML with
bulkload. I use a VB script file to perorm the load with the map schemas and
the XML files. To do the load manually, you just double click on the VB
script file which lies in a directory on the hard drive. Now I want to
execute this file from a VB application or a Windows service. How do I call,
reference or execute the file from VB.net?

[J. Kingsley]

Thanks, it works! A simple piece of code, but you saved me a lot of time.

"David Williams , VB.NET MVP" wrote:

You should be able to use Process.Start("SQL.VBS") [Where you replace
"SQL.VBS" with your named .vbs file] to run the script file.

HTH

David

"J. Kingsley" <JK*******@discussions.microsoft.com> wrote in message
news:2D**********************************@microsof t.com:

I am loading XML data into a SQL Server database using SQLXML with
bulkload. I use a VB script file to perorm the load with the map schemas and
the XML files. To do the load manually, you just double click on the VB
script file which lies in a directory on the hard drive. Now I want to
execute this file from a VB application or a Windows service. How do I call,
reference or execute the file from VB.net?