You can schedule the DTS package to run automatically.

Or you even write a DTS (In VB format) to check the
changes in that text file and run DTS import if there
is any changes.

refer to BOL.

--- Evan Pease <[Email Address Removed] wrote:
>
>
> Hey everybody, i'm sort of a newbie with DTS. I set
> up a DTS package that
> Imports a text file into one of my database tables.
> This text file will be
> generated once or more daily in a specified
> directory. My question is;
>
> Is there a way to get DTS to automaticly execute the
> package on a daily
> basis or on some other condition that would know the
> file changed? Or do I
> need to write a VB program to do this? Thanks
>
>
_________________________________________________________________
> Protect your PC - get McAfee.com VirusScan Online
>
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
>
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> To unsubscribe, e-mail:
> mssqldba-[Email Address Removed] For additional commands, e-mail:
> mssqldba-[Email Address Removed]


=====

Best Regards,
Bajal Mohamed.

YOUR ATTITUDE IS YOUR ALTITUDE




__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/
MS Sql Server LazyDBA home page