Extract Exchange 2003 data

I have searched everywhere for an answer and seems I am either blind or there is no simple solution. Basically I have a need to report on data stored in an Exchange 2003 data store. There is mention of a OLE DB for Exchange 2000 but nothing for Exchange 2003. For example, A company report on time spent on various categories in a staff's calendar, etc. I would like to use SQl 2005 SSIS to extract and reporting services to report. Why is this so difficult? I come from a Lotus Notes / Domino background and there are numerous articles and ways to do this? Please can some MS guru please give me some direction on where to look?

Cheers

Damien

Damien,

Have a look at this Microsoft support page: http://support.microsoft.com/?kbid=813349

It lists the various methods to access Exchange programmically and status of support. I used to use CDO for this type of access...

Frank

|||

Frank,

Once again this artile is date 2005 and yet still only mentions Exchange 2000 and 5.5? I am confused does microsoft not know that 2003 exists at this date?

Sureley there must be a relevant article for 2003? Anywhere?

Cheers

Damien

|||

Damien,

Try this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/e2k3/e2k3/_exchserv2k_provider_extensions.asp

This is from the Exchange 2003 SDK. It lists relevant API's for accessing the Exchange 2003 store.

Frank

External Images - 404 Not Found and the red X image

Hello,
I have a report that is attempting to go out and grab images for certain
items off of a website. The URL is basically a guess and when it is
incorrect (404 File Not Found) RS returns an image of a red X. Is there an
expression I can use to hide the visibilty of the red X if one should appear?
I havn't been able to figure out how to do this.
Thanks!
Paulchecking the binary stream return value and if there is nothing then hide
the column displaying the image
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:616E1484-1B3D-4393-8974-F7C616A6051A@.microsoft.com...
> Hello,
> I have a report that is attempting to go out and grab images for certain
> items off of a website. The URL is basically a guess and when it is
> incorrect (404 File Not Found) RS returns an image of a red X. Is there
> an
> expression I can use to hide the visibilty of the red X if one should
> appear?
> I havn't been able to figure out how to do this.
> Thanks!
> Paul|||Ok, thanks for the post. How exactly do I go about checking the binary
stream return value in RS?
"Vaibhav" wrote:
> checking the binary stream return value and if there is nothing then hide
> the column displaying the image
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:616E1484-1B3D-4393-8974-F7C616A6051A@.microsoft.com...
> > Hello,
> >
> > I have a report that is attempting to go out and grab images for certain
> > items off of a website. The URL is basically a guess and when it is
> > incorrect (404 File Not Found) RS returns an image of a red X. Is there
> > an
> > expression I can use to hide the visibilty of the red X if one should
> > appear?
> > I havn't been able to figure out how to do this.
> >
> > Thanks!
> > Paul
>
>

Extended stored procedure xp_cmdshell

Hello,

I have a question regarding the extended SPC 'xp_cmdshell'.

Basically I want to determine the username and userdomain in a stored procedure and what I know is that you can get this information in a "DOS-Box" with 'Set username' or 'Set userdomain'.

But if I use the above mentioned extended stored procedure in the following way:

exec master..xp_cmdshell 'set username'

I don´t get any resultset.

Does anyone know why I get different results depending on the fact if I call the 'set'-command in a "DOS-Box" or with the appropriate stored procedure?

Thank you for any help>>Basically I want to determine the username and userdomain in a stored procedure and what I know is that you can get this information in a "DOS-Box" with 'Set username' or 'Set userdomain'.

You are aware that xp_xmdshell is running in the context of Sql Server. So you will only ever see information pertaining tho the server - not any client.

What user and domain are you trying to retrieve? The client connecting to SQL Server or the Server itself?|||Hello,

yes, you are absolutely right! I am aware of this but I have just tried this on my local machine. I have installed SQL-server local and I was just wondering because of this differences on the same machine. I know that I can´t use this in a production environment because of the fact that this SPC is running in the context of the server and does not affect any client.

What I basically want is to retrieve the domainname and -user of the client connection with a stored procedure.

Do you know a practicable method to do this?

Thanks,|||SQL Server provides several functions for this purpose each with differing behavior. Have a look in SQL Server Books Online at the following keywords for starters:

USER_NAME()
SESSION_USER
USER|||Hello,

thank you for the advice to the functions of sql server. I have looked around now for a while and have found a function which returns indeed the domainname and domainusername of the connected client.
Just beside -- the functions you mentioned just give back the actually sql-server user in the selected database which is in my environment always 'dbo'.

You can get the domaininfo with the following piece of code:DECLARE @.System_User char(30)
SET @.System_User=SYSTEM_USER
PRINT @.System_UserRegards,

Expression for Jump to Report

Hi Experts,
Can anyone tell me how to specify an expression to be mentioned in the "Jump
to Report" in the Navigation tab. I basically dont want the hyperlink for
some values.
= iif( Fields!ItemCount.Value = 0, "", "Detail")
this is the expression which I have currently given. I dont want the
hyperlink when the ItemCount = 0. But now it points to the same page since I
have given empty string. How can I handle this.
Thanks in Advance
GaneshHi,
Instead of empty string just put "Nothing" word. This will solve your problem.
Regards
Amarnath
"Ganesh Ramamurthy" wrote:
> Hi Experts,
> Can anyone tell me how to specify an expression to be mentioned in the "Jump
> to Report" in the Navigation tab. I basically dont want the hyperlink for
> some values.
> = iif( Fields!ItemCount.Value = 0, "", "Detail")
> this is the expression which I have currently given. I dont want the
> hyperlink when the ItemCount = 0. But now it points to the same page since I
> have given empty string. How can I handle this.
> Thanks in Advance
> Ganesh
>
>|||Thanx Amar for the reply,
i tried that = iif( Fields!ItemCount.Value = 0, "Nothing", "Detail")...
I get the following error
The item '/Reports/Nothing' cannot be found. (rsItemNotFound)
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:3FEC77CE-9386-48E4-87CB-171F9EBBC053@.microsoft.com...
> Hi,
> Instead of empty string just put "Nothing" word. This will solve your
> problem.
> Regards
> Amarnath
> "Ganesh Ramamurthy" wrote:
>> Hi Experts,
>> Can anyone tell me how to specify an expression to be mentioned in the
>> "Jump
>> to Report" in the Navigation tab. I basically dont want the hyperlink for
>> some values.
>> = iif( Fields!ItemCount.Value = 0, "", "Detail")
>> this is the expression which I have currently given. I dont want the
>> hyperlink when the ItemCount = 0. But now it points to the same page
>> since I
>> have given empty string. How can I handle this.
>> Thanks in Advance
>> Ganesh
>>|||Amar..
Sorry for the Previous reply...now it is working correct...I had put Nothing
in quotes...
now it is working fine...quite a long time since worked in VB...
Thanks again
Ganesh
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:3FEC77CE-9386-48E4-87CB-171F9EBBC053@.microsoft.com...
> Hi,
> Instead of empty string just put "Nothing" word. This will solve your
> problem.
> Regards
> Amarnath
> "Ganesh Ramamurthy" wrote:
>> Hi Experts,
>> Can anyone tell me how to specify an expression to be mentioned in the
>> "Jump
>> to Report" in the Navigation tab. I basically dont want the hyperlink for
>> some values.
>> = iif( Fields!ItemCount.Value = 0, "", "Detail")
>> this is the expression which I have currently given. I dont want the
>> hyperlink when the ItemCount = 0. But now it points to the same page
>> since I
>> have given empty string. How can I handle this.
>> Thanks in Advance
>> Ganesh
>>

Exporting Stored Procedures

I have to retrieve all the stored procedures in a certain database via a aspx page. My problem is that I have basically no idea how to do it. I did manage to get all the data as XML and reconstruct the database (pain). All I need now (I hope) is the sprocs. I do not have any other access to the database. And I'm a novice with SQL Server. Any guidance is appreciated.

SteveSomething like:

select text
from syscomments
where text like 'create procedure%'

|||Thank you very much.

I also have to restore the sprocs. Should I select all the columns in syscomments and sysobjects for the relevent rows and insert them into the new db? Will that do it?

Thanks again,

Steve|||NO, I do not recommend this approach.. Why are you looking to perform these activities through an asp.net application?|||I have a client with a developer problem. They asked me to coordinate with the developer to facilitate moving the site. Despite the developer's statements that I could access the SQL Server, he only gave me FTP access to the site. Eventually, I find out that he is intentionally being difficult, refusing to assist unless the client paid him more money. Apparently a _lot_ more money. I found in his connection code where he recently changed the pw to the database, to something other than what he told me. I assume the developer is being unreasonable to the point where it is cheaper to have me do it the "hard" way. Oh yeah, this is a classic ASP app, which I have no experience with either.

So... I had to use an aspx page to get the data via XML. Easy enough, but restoring it was a bit more challenging. I finally have the tables restored properly; now all I need is the stored procedures (I hope).

I did get the procedures (thanks again), however I had to get all the rows because none of the sprocs begin with the string you suggested, and I'm wanderin' around in the dark.

I'm amazed I've accomplished what I have. It's a good thing .NET is so smart. :)

Steve|||Thanks to your help, I was able to completely reconstruct the database!

I had to manually re-add the stored procedures, views & triggers I got from your suggestion. In the end, it was the easiest way.

Thanks again,

Steve

exporting SQL data as Access readable file

hi guys.
i'm looking to try and get a web tool together that will basically allow a user to download a file that can be plopped into MS Access, using the data i have on my servers stored in MS SQL Server...
any ideas?nobody, huh?|||bcp out a data file?

You need to be clearer on your process and what you're trying to do..

I'd venture to say that a stored procedure will be called, then using xp_cmdshell bcp out a view or use queryout...

But a little more explination would help us...