To answer your question, there's sample code on executing a DTS Package from VB in the articles under Programming -> Visual Basic. You'll want to look to MSDN on...

That occurred to me after I made the post. I just stumbled across a class that is going to get me started using .NET. FileSystemWatcher. I can...

Back to my original response. Pass the machine name in from the front end. A trigger would catch the changes made by different applications. Maybe you need...

I think a combination of a sql job and dts packages will give you want you want.

I think the point Andy was making is that SQL will only give you the host_name() provided in the connection string. MS Access will store the machine name when...

I'll get right on that.

Host_Name()

That's cool! I didn't know you could do that.

Steve,

How do you get Hostname from the system? I got:

Server: Msg 195, Level 15, State 10, Line 1

'hostname' is not a recognized function name.

Can you identify the box by...

I think you'll need to pass this from the user interface.

So yvan should end up with something like this?

replace(isnull(cast(My_Column as char), 'NULL'), 'NULL', '')

I don't know what kind of vbscript transformations you're doing. Most I've seen are string manipulations combined with if then logic. This can all be done in SQL. ...

Thanks for the reply. I've never created a linked server in code before. I'll look into that. Sounds like a good option.

With regards to the DTS vs TSQL comment,...

I agree the SQL box should remain SQL only. Fault tolerance is also a good idea. Nobody wants to go back to pen and paper! What are the...

quote:

---

the ultimate result set I want doesn't seem to be returned to my application, but rather the select for the code is...

Does your nested stored procedure return an output parameter?