Mailing Lists

Hi All

We are running SQL Server & Outlook with an exchange server. We are
looking for a way to import the address book & email details into a
database table.

We have managed to do this with MS Access by using the import option
exchange(). Is there a similar way this can be done in SQLServer 2000"Mick Kehoe" <mick@.kehoe.demon.co.uk> wrote in message
news:86917a0f.0409220431.21399510@.posting.google.c om...
> Hi All
> We are running SQL Server & Outlook with an exchange server. We are
> looking for a way to import the address book & email details into a
> database table.
> We have managed to do this with MS Access by using the import option
> exchange(). Is there a similar way this can be done in SQLServer 2000

I'm not familiar with Exchange, however if you can export the addresses to a
CSV file, then DTS or bcp.exe can import the data. Alternatively, if you
already have them in Access, then you could use DTS or a linked server to
pull them into MSSQL.

Simon|||From MS SQL 2k Books On Line ...

The Microsoft OLE DB Provider for Exchange exposes data stored in a
Microsoft Exchange 2000 Web Store in tabular form. This data can be queried
using an SQL-like language that is very similar to the SQL subset supported
by the OLE DB Provider for Microsoft Indexing Service.

Microsoft SQL ServerT 2000 distributed queries can be used to query data
from the Exchange Web Store through this OLE DB Provider and can be joined
with tables in SQL Server. The Exchange Web Store should be located in the
same computer as SQL Server. Web Stores located in other computers cannot be
accessed using the OLE DB Provider for Exchange.

"Simon Hayes" <sql@.hayes.ch> wrote in message
news:41517712$1_1@.news.bluewin.ch...
> "Mick Kehoe" <mick@.kehoe.demon.co.uk> wrote in message
> news:86917a0f.0409220431.21399510@.posting.google.c om...
> > Hi All
> > We are running SQL Server & Outlook with an exchange server. We are
> > looking for a way to import the address book & email details into a
> > database table.
> > We have managed to do this with MS Access by using the import option
> > exchange(). Is there a similar way this can be done in SQLServer 2000
> I'm not familiar with Exchange, however if you can export the addresses to
a
> CSV file, then DTS or bcp.exe can import the data. Alternatively, if you
> already have them in Access, then you could use DTS or a linked server to
> pull them into MSSQL.
> Simon

mail client and dts send mail task

Hi,
Is it required to have microsoft outlook client up-and-running to send mail from dts package?
I have a dts package which send email if job fail or success. will it work fine if someone by mistek close outlook client running on server?
please reply.
Ram.No, the outlook client does not have to be running to use send-mail in a dts package.

The outlook client needs to be installed on the server and the profile needs to be created for the user context that will be running the dts package.

Here is where the confusion typically lies. When you run a DTS package interactively, the security context is who-ever you are logged in as. As such, it is relatively easy to debug. What most people don't understand is that if the DTS package is running based on some automated feature (timer, or another application starting it) the DTS package typically runs under the SQL Agent ID (Check the logon-id of the user that starts SQL Agent in control panel Services). You will need to use a specific ID, rather than system. This is because to use SQL Mail, you will have to interactively log-on as that user and configure outlook. Once you have done that, the SQL Agent will be able to send and receive e-mail without you being logged in.

Good luck.|||Originally posted by rmillman
No, the outlook client does not have to be running to use send-mail in a dts package.

The outlook client needs to be installed on the server and the profile needs to be created for the user context that will be running the dts package.

Here is where the confusion typically lies. When you run a DTS package interactively, the security context is who-ever you are logged in as. As such, it is relatively easy to debug. What most people don't understand is that if the DTS package is running based on some automated feature (timer, or another application starting it) the DTS package typically runs under the SQL Agent ID (Check the logon-id of the user that starts SQL Agent in control panel Services). You will need to use a specific ID, rather than system. This is because to use SQL Mail, you will have to interactively log-on as that user and configure outlook. Once you have done that, the SQL Agent will be able to send and receive e-mail without you being logged in.

Much thanks for your reply. explains me how dts send email . nothing to do with up-and-running mail client . it sends email internally useing agent.
cool.

Good luck.|||There's a great email extended procedure you can get that will allow you to send email without installing the outlook client on all your SQL servers. You can go this link for details: http://sqldev.net/xp/xpsmtp.htm

We have implemented this at LexisNexis by writing a wrapper procedure that calls the extended procedure. This provides a higher level security. You can call this from within a DTS package or via a job step within a scheduled job. We've been using this for quiet awhile with great success in all our maintenance plans for backups.