Re: Triggering a DTS Package
From: Greg Linwood (g_linwoodQhotmail.com)
Date: 07/28/04
- Next message: Greg Linwood: "Re: Access vs SQL"
- Previous message: Sanjay: "Re: sysadmin priveledges"
- In reply to: Sanjay: "Triggering a DTS Package"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Jul 2004 08:07:20 +1000
Hi Sanjay
SQL can't tell you when a file appears in a directory - you'd need to do
that using other tools such as the .Net FileSystemWatcher framework class.
Depending on how you built that component (this would be better asked in a
development newsgroup) you could then connect to SQL Server & execute the
DTS task either via it's COM interface, using the DTSRUN.exe utility or the
sp_start_job TSQL command.
HTH
Regards,
Greg Linwood
SQL Server MVP
"Sanjay" <Sanjay@discussions.microsoft.com> wrote in message
news:18D0F8CD-604A-4019-B436-DACB566B5BB2@microsoft.com...
> I have a DTS task which starts from Test File Source inserting data into a
Table
> I Want this package to be Triggered when a file arrives in a particular
directory instead of being sheduled.
>
> How can i do this ?
>
> Thanks
> Sanjay
>
>
- Next message: Greg Linwood: "Re: Access vs SQL"
- Previous message: Sanjay: "Re: sysadmin priveledges"
- In reply to: Sanjay: "Triggering a DTS Package"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
