Job Fails accessing mapped drive

I built a package in SSIS that exports some data in a database and writes it to a flat file. The flat file is written to a mapped drive on another server (shared folder). The package runs without failure in SSIS and when I deploy it on the SQL Server. The problem comes when I try to run the package as a job; it fails. If I change the file location to the local c: drive, the job runs to sucess. The id that starts the SQL Server Agent is a domain id that is included in both the domain admin group and the local admin group. All the job log indicates is that the job failed; no details.

What am I missing?

ThanksFully qualifying the share fixed the problem. Sure would like to understand why.

job email

hi
i'm new to sql administration.
the built in sp for email uses a single account to send email.
i have a table (fromEmail, fromName, toEmail, toName, subject,
content). the fromXXX fields are dynamic.
is there another sp that can send mail with these parameters?
how could i do this?
thanx
riyazwhat built in sp did you try?
sp_send_dbmail in sql server 2005 has a @.profile_name argument which is the
name of the profile to send the message from.
hth,
Cristian Babu
<rmanchu@.gmail.com> wrote in message
news:1147241986.934852.156770@.i40g2000cwc.googlegroups.com...
> hi
> i'm new to sql administration.
> the built in sp for email uses a single account to send email.
> i have a table (fromEmail, fromName, toEmail, toName, subject,
> content). the fromXXX fields are dynamic.
> is there another sp that can send mail with these parameters?
> how could i do this?
> thanx
> riyaz
>|||One that I use ,(it's not built in you will have to apply, straightforward)
is XPSMTP on .http://www.sqldev.net/xp/xpsmtp.htm
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
<rmanchu@.gmail.com> wrote in message
news:1147241986.934852.156770@.i40g2000cwc.googlegroups.com...
> hi
> i'm new to sql administration.
> the built in sp for email uses a single account to send email.
> i have a table (fromEmail, fromName, toEmail, toName, subject,
> content). the fromXXX fields are dynamic.
> is there another sp that can send mail with these parameters?
> how could i do this?
> thanx
> riyaz
>|||One that I use ,(it's not built in you will have to apply, straightforward)
is XPSMTP on .http://www.sqldev.net/xp/xpsmtp.htm
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
<rmanchu@.gmail.com> wrote in message
news:1147241986.934852.156770@.i40g2000cwc.googlegroups.com...
> hi
> i'm new to sql administration.
> the built in sp for email uses a single account to send email.
> i have a table (fromEmail, fromName, toEmail, toName, subject,
> content). the fromXXX fields are dynamic.
> is there another sp that can send mail with these parameters?
> how could i do this?
> thanx
> riyaz
>|||Jack Vamvas wrote:
> One that I use ,(it's not built in you will have to apply, straightforward
)
> is XPSMTP on .http://www.sqldev.net/xp/xpsmtp.htm
had a look. seems solid.
but how do i specify the name/email of the recipients? is this
possible? is there a format?
eg: John Doe <jdoe@.trademin.gov.mv>, Jane Doe <email>
thanx
riyaz