OLE Automation in T-SQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » OLE Automation in T-SQL

OLE Automation in T-SQL

Rate Topic

Display Mode

Topic Options

Author

Message

renu.iitkgp

Posted Monday, January 18, 2010 7:49 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, September 05, 2012 5:56 AM
Points: 12, Visits: 31

Hello,

I have been trying to find any resources about OLE Automation in T-SQL. The problem right now is:

I have a file at a location on the server. I want the binary content of the file to be stored in an XML variable and lets say, I want to insert that xml variable in a table (which ofcourse has a column of datatype xml).

I know that this could be done using spOA system stored procedures.
I could find several other things with spOACreate, except any useful resource for 'scripting.filesystemobject'.

Googling or MSDN'in didn't help a bit.

Can any one help me with this please?

Thanks and Regards,
Renuka Prasad.

Post #849173

Sigerson

Posted Monday, September 10, 2012 6:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:27 AM
Points: 181, Visits: 582

Try this page: http://msdn.microsoft.com/en-us/library/bstcxhf7(v=VS.85).aspx

All the methods, properties, and lots of examples.

Sigerson

"No pressure, no diamonds." - Thomas Carlyle

Post #1356686

« Prev Topic | Next Topic »

Permissions