Can an email trigger a DTS Package?

9 Sep 2006 11:27 AM

jaylou

I get an email to let me know files are ready for processing. Can I set
something up to kick off the job?

TIA,
Joe

10 Sep 2006 6:42 AM

Arnie Rowland

You could have a job that looks every x minutes/seconds/hours for a file in
a folder, and if one is found, start a DTS package using DTSRun.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

Show quote

"jaylou" <jay***@discussions.microsoft.com> wrote in message
news:0B81EF2B-7F14-4909-9E7F-0C6918DB363B@microsoft.com...
>I get an email to let me know files are ready for processing. Can I set
> something up to kick off the job?
>
> TIA,
> Joe

11 Sep 2006 1:38 PM

jaylou

Arnie Rowland wrote:
Show quote

> You could have a job that looks every x minutes/seconds/hours for a file in
> a folder, and if one is found, start a DTS package using DTSRun.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "jaylou" <jay***@discussions.microsoft.com> wrote in message
> news:0B81EF2B-7F14-4909-9E7F-0C6918DB363B@microsoft.com...
> >I get an email to let me know files are ready for processing. Can I set
> > something up to kick off the job?
> >
> > TIA,
> > Joe

11 Sep 2006 1:41 PM

jaylou

Thanks,
I was hoping to avoid that.

Arnie Rowland wrote:
Show quote

> You could have a job that looks every x minutes/seconds/hours for a file in
> a folder, and if one is found, start a DTS package using DTSRun.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> "jaylou" <jay***@discussions.microsoft.com> wrote in message
> news:0B81EF2B-7F14-4909-9E7F-0C6918DB363B@microsoft.com...
> >I get an email to let me know files are ready for processing. Can I set
> > something up to kick off the job?
> >
> > TIA,
> > Joe

11 Sep 2006 1:56 PM

Tracy McKibben

jaylou wrote:

> Thanks,
> I was hoping to avoid that.
>

What exactly are you looking for? SQL Server doesn't receive email.
You could kludge together something using xp_readmail, but Microsoft
warns you not to use that xp, and it's going away in an upcoming release.

You're going to need a mail server to receive the incoming email
message, depositing it into a mailbox, or dumping it to a disk file
somewhere. You will then need a process (in SQL or elsewhere) to
monitor that mailbox or file location for new arrivals.

One thing you could do, if you really need to pull this off, is to
install Outlook on the server (be absolutely 100% certain that you
REALLY want to do this), and setup an Outlook rule to run a script that
launches DTSRUN.

--
Tracy McKibben
MCDBA
http://www.realsqlguy.com