Automatic Import of Emails

Is there a way to automatically import incoming emails into a SQL
Server Database?
I know it is inefficient, but we have to run a number of rules on the
email after it is received. Store it in a database and be able to
connect other things, meetings, contacts, etc. Moving it back and
forth in chunks can be difficult and the overhead could spiral out of
control.
So we were thinking of moving it to the DB as it was retrieved.
What do you think would be a better solution to retrieve it?
Does my email make sense?Am 14 Jul 2006 01:13:51 -0700 schrieb leeroy881:

Quote:

Originally Posted by

Is there a way to automatically import incoming emails into a SQL
Server Database?

Maybe not import, but read. See xp_readmail/xp_findnextmsg (in SQL2000 sp3
and up) in BOL. With this and ServerAgent you can implement an automatic
mail processing system.

bye, Helmut|||Thank you Helmut.
I'll check it out.

Helmut Woess wrote:

Quote:

Originally Posted by

Am 14 Jul 2006 01:13:51 -0700 schrieb leeroy881:
>

Quote:

Originally Posted by

Is there a way to automatically import incoming emails into a SQL
Server Database?

>
Maybe not import, but read. See xp_readmail/xp_findnextmsg (in SQL2000 sp3
and up) in BOL. With this and ServerAgent you can implement an automatic
mail processing system.
>
bye, Helmut

Automated loading .CSVs into SQL Server

I am new to SQL Server and would be greatful for any assistance you
may be able to provide.
I have an incoming directory that recieves .csv files are regular
intervals. I need to be able to identify when these files arrive and
then load them into SQL Server into seperate tables overwriting the
current data. I was looking to use DTS, however i have never used it
before.
Could you assist or refer me to any useful sources?
Thank you in advance.Visit at www.sqldts.com
<dipeshpatel316@.gmail.com> wrote in message
news:1170760628.739101.96140@.a34g2000cwb.googlegroups.com...
>I am new to SQL Server and would be greatful for any assistance you
> may be able to provide.
> I have an incoming directory that recieves .csv files are regular
> intervals. I need to be able to identify when these files arrive and
> then load them into SQL Server into seperate tables overwriting the
> current data. I was looking to use DTS, however i have never used it
> before.
> Could you assist or refer me to any useful sources?
> Thank you in advance.
>

Automated loading .CSVs into SQL Server

I am new to SQL Server and would be greatful for any assistance you
may be able to provide.
I have an incoming directory that recieves .csv files are regular
intervals. I need to be able to identify when these files arrive and
then load them into SQL Server into seperate tables overwriting the
current data. I was looking to use DTS, however i have never used it
before.
Could you assist or refer me to any useful sources?
Thank you in advance.
Visit at www.sqldts.com
<dipeshpatel316@.gmail.com> wrote in message
news:1170760628.739101.96140@.a34g2000cwb.googlegro ups.com...
>I am new to SQL Server and would be greatful for any assistance you
> may be able to provide.
> I have an incoming directory that recieves .csv files are regular
> intervals. I need to be able to identify when these files arrive and
> then load them into SQL Server into seperate tables overwriting the
> current data. I was looking to use DTS, however i have never used it
> before.
> Could you assist or refer me to any useful sources?
> Thank you in advance.
>

Automated loading .CSVs into SQL Server

I am new to SQL Server and would be greatful for any assistance you
may be able to provide.
I have an incoming directory that recieves .csv files are regular
intervals. I need to be able to identify when these files arrive and
then load them into SQL Server into seperate tables overwriting the
current data. I was looking to use DTS, however i have never used it
before.
Could you assist or refer me to any useful sources?
Thank you in advance.Visit at www.sqldts.com
<dipeshpatel316@.gmail.com> wrote in message
news:1170760628.739101.96140@.a34g2000cwb.googlegroups.com...
>I am new to SQL Server and would be greatful for any assistance you
> may be able to provide.
> I have an incoming directory that recieves .csv files are regular
> intervals. I need to be able to identify when these files arrive and
> then load them into SQL Server into seperate tables overwriting the
> current data. I was looking to use DTS, however i have never used it
> before.
> Could you assist or refer me to any useful sources?
> Thank you in advance.
>