Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
venkat09
Starting Member
17 Posts |
 Posted - 2010-01-18 : 09:41: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. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-18 : 12:43:34
|
| http://msdn.microsoft.com/en-us/library/hww8txat(VS.85).aspx |
 |
|
|
|
|
|
OLE Automation in T-SQL