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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-19 : 11:14:56
|
| Sherif writes "hey, thanks for reading.i'm aware of sp_OA* stored proc family for invoking COM. i'm also aware of Interop with .Neti'm wondering if there is a pure .Net equivalent. moreover, i'm interested in making a choice. i've explained briefly what i think some of my options are...essentially what i have is a single table and i want to write out the contents of each field to a separate file and then store them in a zip archive. one of the fields contains a JPEG image. one of the fields a text file. a third field the GUID for the record, etc. The zip archived file has a manifest describing contents and relative paths within the archive. i already have a working zip archive writer. sure, i can populate the method parameters with data from a query, but...i can think of many ways to handle this and i have no idea how to begin _evaluating_ them, including triggered sp_OA* family to COM, or to Interop to .Net for that matter, or maybe even SQL Agent to xp_cmdshell to .Net executable, etc. etc.hopefully this makes clear sense and isn't already posted. i looked for some time and found only a COM related article reminding me of the sp_OA* stuff.thanks for your input." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2004-04-19 : 23:15:42
|
| HiAt the moment, there isn't a native way to do it. In Yukon you will be able to call managed code in a similar way to extended procs, but that doesn't help you today.There are three ways you can handle this :1. COM interop so you can call a DLL with sp_OA2. Use xp_CmdShell to call a .NET exe.3. Have a .NET exe that runs externally (on a schedule) that gets a dataset back and processes it.Damian |
 |
|
|
|
|
|
re: evaluating options for invoking dotnet programs from T-SQL