 | |
Can DTS receive emails?
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Can DTS receive emails? -
01-11-2005
, 06:01 AM
#2
| |||
| |||
|
|
Scenario: client wishes to create a utility email account at his company (utility (AT) blah (DOT) com) and have flatfiles (typically sent as zip email attachments) emailed directly to it. He wishes to have some form of automation set up to where the flatfile is received by the utility email, automatically extracted, and directly imported into sqlserver. DTS is of course able to send emails, but does anyone know if it's possible to *receive* emails? Or is what I described above beyond the scope of DTS's power? TIA |
#3
| |||
| |||
|
|
Scenario: client wishes to create a utility email account at his company (utility (AT) blah (DOT) com) and have flatfiles (typically sent as zip email attachments) emailed directly to it. He wishes to have some form of automation set up to where the flatfile is received by the utility email, automatically extracted, and directly imported into sqlserver. DTS is of course able to send emails, but does anyone know if it's possible to *receive* emails? Or is what I described above beyond the scope of DTS's power? TIA |
#4
| |||
| |||
|
|
Not DTS Per se but you can use the extended stored procs xp_readmail et al -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - You thought DTS was good. here we show you the new stuff. www.konesans.com - Consultancy from the people who know "roda" <royda987NOSPAM (AT) yahoo (DOT) com> wrote in message news:34htmdF4bmk68U1 (AT) individual (DOT) net... Scenario: client wishes to create a utility email account at his company (utility (AT) blah (DOT) com) and have flatfiles (typically sent as zip email attachments) emailed directly to it. He wishes to have some form of automation set up to where the flatfile is received by the utility email, automatically extracted, and directly imported into sqlserver. DTS is of course able to send emails, but does anyone know if it's possible to *receive* emails? Or is what I described above beyond the scope of DTS's power? TIA |
#5
| |||
| |||
|
|
Hmmm. I recognize you Allan as one of the resident gurus... you wouldn't happen to have any links handy would you? Or is this relatively uncharted/unused territory? Thanks Melih! Thanks Allan! "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uDifmtA%23EHA.3472 (AT) TK2MSFTNGP14 (DOT) phx.gbl... Not DTS Per se but you can use the extended stored procs xp_readmail et al -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - You thought DTS was good. here we show you the new stuff. www.konesans.com - Consultancy from the people who know "roda" <royda987NOSPAM (AT) yahoo (DOT) com> wrote in message news:34htmdF4bmk68U1 (AT) individual (DOT) net... Scenario: client wishes to create a utility email account at his company (utility (AT) blah (DOT) com) and have flatfiles (typically sent as zip email attachments) emailed directly to it. He wishes to have some form of automation set up to where the flatfile is received by the utility email, automatically extracted, and directly imported into sqlserver. DTS is of course able to send emails, but does anyone know if it's possible to *receive* emails? Or is what I described above beyond the scope of DTS's power? TIA |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.