Avatar of juarrero
juarrero
Flag for Spain asked on

transact sp_OAMethod's parameters for Scripting.FileSystemObject object

Hello:

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,

Juarrero
Microsoft SQL Server* AutomationSQL* OLE

Avatar of undefined
Last Comment
Máté Farkas

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Máté Farkas

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Máté Farkas

User did not react on a perfect and tested answer.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck