Results 1 to 2 of 2
  1. #1
    Join Date
    May 2009
    Posts
    5

    Unanswered: OLE Automation in T-SQL

    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.

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    I would avoid using OLE Automation in T-SQL if you can - it is ugly in the extreme. I would either use managed code or (possibly - I'm not 100% certain if it can be done for this though I think it should) native T-SQL.
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •