We help IT Professionals succeed at work.
Get Started

transact sp_OAMethod's parameters for Scripting.FileSystemObject object

Last Modified: 2017-12-25

I am working with OLE Automation to deal with windows folders and files from inside SQL Server.

I can create an object of type Scripting.FileSystemObject. But when using the stored procedure sp_OAMethod to perform some work on it, I barely know a few parameters as 'FolderExists' or 'CreateFolder'.

I have found some pages like https://msdn.microsoft.com/en-us/library/ch28h2s7(v=vs.84).aspx with provides a description for a set of specific methods of the object for VBScript and JScript, equivalent to use "sp_OAMethod + parameter" in transact.

I would need to find out the same detailed information for transact sp_OAMethod for Scripting.FileSystemObject. Thas is, information of the many parameters for this method and object.

Thanks in advance,

Watch Question
SQL Server Consultant
Distinguished Expert 2020
This problem has been solved!
Unlock 1 Answer and 2 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE