How to transfer Microsoft Outlook data into SQL Server 2000 \ 2005

Hello,
I am looking for a process where by I can transfer Outlook data (Emails)
into SQL Server 2000 \ 2005 for certain urgent analysis.
Can some one please explain me how to accomplish this task?
Thanks in advance.
SurajitDo an EXPORT from Outlook into some sort of CSV file - and then do an IMPORT
into SQL Server via the import/export function
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Make SQL Server faster - www.quicksqlserver.com
___________________________________
"surajits" <surajits@.discussions.microsoft.com> wrote in message
news:FBA08A4D-3094-428C-8B87-56C47DA98C84@.microsoft.com...
> Hello,
> I am looking for a process where by I can transfer Outlook data (Emails)
> into SQL Server 2000 \ 2005 for certain urgent analysis.
> Can some one please explain me how to accomplish this task?
> Thanks in advance.
> Surajit
>sql

How to transfer Microsoft Outlook data into SQL Server 2000 \ 2005

Hello,
I am looking for a process where by I can transfer Outlook data (Emails)
into SQL Server 2000 \ 2005 for certain urgent analysis.
Can some one please explain me how to accomplish this task?
Thanks in advance.
SurajitDo an EXPORT from Outlook into some sort of CSV file - and then do an IMPORT
into SQL Server via the import/export function
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
Make SQL Server faster - www.quicksqlserver.com
___________________________________
"surajits" <surajits@.discussions.microsoft.com> wrote in message
news:FBA08A4D-3094-428C-8B87-56C47DA98C84@.microsoft.com...
> Hello,
> I am looking for a process where by I can transfer Outlook data (Emails)
> into SQL Server 2000 \ 2005 for certain urgent analysis.
> Can some one please explain me how to accomplish this task?
> Thanks in advance.
> Surajit
>

How to Test a Subscription

Hello,
I've currently got some email subscriptions setup to go out every 1 minute
(for testing purposes), but I'm not getting any emails and nowhere can I
find an error reported.
Is there a best practices for testing and troubleshooting subscriptions that
don't go out?
Any advice would be greatly appreciated!
Regards,
Benjamin PierceRegards,
I was able to figure out my problem -- it turns out that the ReportServer
Service was turned off (it's always the last place you look).
Just to share a little bit of knowledge with the RS users out there, here
are a few of the ways I personally troubleshoot subscriptions.
1) In the ReportServer database, execute the following query:
SELECT * FROM Event ORDER BY TimeEntered DESC
This will return the number of events in the queue. If items remain in this
queue for more than a minute or two, either the service is not on, something
is blocking in the database, or the service is hung.
2) Open SQL Enterprise Manager and check out the jobs. There should be a
job in your Enterprise Manager for each subscription. It might be useful to
look at the Event History, and check the error logs.
3) Of course, you'll also want to make sure you test the SMTP server that
you've got setup. A lot of the time the problem lies in the email setup
(possibly file sizes quotas, incorrectly configured email groups)...rather
than a Reporting Services thing.
Anyhow, I realize these tips are by no means advanced, but they've helped me
plenty of times and I hope they'll do the same for you.
Best Regards,
Benjamin Pierce
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:eonpvdcbEHA.796@.TK2MSFTNGP09.phx.gbl...
> Hello,
> I've currently got some email subscriptions setup to go out every 1 minute
> (for testing purposes), but I'm not getting any emails and nowhere can I
> find an error reported.
> Is there a best practices for testing and troubleshooting subscriptions
that
> don't go out?
> Any advice would be greatly appreciated!
>
> Regards,
> Benjamin Pierce
>sql