Using host_name() in export path

[JefB]

Can I use host_name() in a DTS export path?

I am trying to export the results of a query to the requestors PC.

Thanks
JefB

 

[Catadmin]

I don't think so. But I think you could write an SP that assigns host_name() to a variable, then executes the DTS package export path with dynamic SQL.



Catadmin - MCDBA, MCSA
"If a person is Microsoft Certified, does that mean that Microsoft pays the bills for the funny white jackets that tie in the back???