Hi,

I have a visual basic app which reads email files from a outlook 2000 account I setup for the database server. It then exports these files to text files which I import into sql server.

I created a dts package which first runs the vb app, and then imports the text files. This works fine if I run it from Enterprise Manager, but when scheduled the package does not access the email account. Is this because the package is run as the system account? Not the user account?

Most probably

http://support.microsoft.com/?kbid=269074



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"John" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi,

I have a visual basic app which reads email files from a outlook 2000
account I setup for the database server. It then exports these files to text
files which I import into sql server.

I created a dts package which first runs the vb app, and then imports the
text files. This works fine if I run it from Enterprise Manager, but when
scheduled the package does not access the email account. Is this because the
package is run as the system account? Not the user account?