OLE Automation in T-SQL

• renu.iitkgp

  Mr or Mrs. 500

  Points: 573

  More actions

  January 18, 2010 at 7:49 am

  #138123

  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.

• Sigerson

  Hall of Fame

  Points: 3697

  More actions

  September 10, 2012 at 6:24 am

  #1535642

  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