How to run Oracle Script from a file

[lxwei60]

How can i run Oracle SQL script from a file by using ADO? Current ADO only accepts text in Comand tab

Thanks
David

[kevina]

Use a Sql Statement value of something like this:

[vbld_GetFileContents("c:\files\test.sql")]

This one line script will read the file contents and pass to the step as a string...