Check XLS file status in DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Thread Tools

Display Modes

Matrix

Posts: n/a

Check XLS file status in DTS - 09-22-2004 , 11:37 AM

How can I identify if an excel file is in use or open. If it is in use or
open then it should abort the DTS and send an email reporting it.

I am using excel file in DTS to do my job but first I want to check if the
File is already in use by other user or process? Please help.

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off