Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

OLE Automation in T-SQL Expand / Collapse
Posted Monday, January 18, 2010 7:49 AM


Group: General Forum Members
Last Login: Monday, June 2, 2014 9:03 AM
Points: 15, Visits: 57

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
Posted Monday, September 10, 2012 6:24 AM

Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, August 31, 2016 10:25 AM
Points: 537, Visits: 1,230
Try this page:

All the methods, properties, and lots of examples.


"No pressure, no diamonds." - Thomas Carlyle
Post #1356686
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse