Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Meta data services packages - issue

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2004-09-10 : 08:41:59
Himanshu writes "Hi team,

I have a doubt in Meta data services packages.
I am using MS SQL Server 2000 in my enterprise.

For regularly generating a report from server and sending it to many clients using ftp and mail and also to have email notification I set up a 'meta data services packages'.

I created the package from my (client) machine. Created 'send mail' task using outlook profile which is located in my local machine.

Now if somebody opens the same meta data services package in his/her machine, the send mail task picks up the profile from his/her machine and I can see that password field is filed with asterisks.

Can you please tell me now when my packages executes (or executes as scheduled) which profile it will use? And why this integration issue?

Awaiting your favorable reply.

Thanks very much in advance.

Himanshu Jani
India."
   

- Advertisement -