Code works in the DTS designer, but fails when run as a job.
Set objFolder = myOlNameSpace.Folders("Public Folders")
Thanks
BJ

This is usually down to permissions and account differences.

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

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

Alan
I logged onto the sevrer using the account.
Open outlook to public folders.
Also ran the job in the DTS designer OK.
Ran as a job an it fails.

What is the error you get?

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

Executed as user: hra\sqlagent. ...ing... DTSRun OnStart:
DTSStep_DTSActiveScriptTask_1 DTSRun OnError:
DTSStep_DTSActiveScriptTask_1, Error = -2147220482
(800403FE) Error string: Error Code: 4096 Error
Source= Microsoft Outlook Error Description: Could not
complete the operation because the service provider does
not support it. Error on Line 51 Error source:
Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 4500
Error Detail Records: Error: -2147220482 (800403FE);
Provider Error: 0 (0) Error string: Error Code: 4096
Error Source= Microsoft Outlook Error Description:
Could not complete the operation because the service
provider does not support it. Error on Line 51
Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts80.hlp Help
context: 4500 DTSRun OnFinish:
DTSStep_DTSActiveScriptTask_1 DTSRun: Package execution
.. The step failed.

Hmmmm

This may have to do with Outlook not having a logged on user at the time.
From what I read of Outlook and running unattended most people swap this out
and use CDO.

Can you do this?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

Never used CDO.
I will look into adding some code to log onto OUTLOOK from
the job.

Thanks

MUCH better off using CDO:

http://msdn.microsoft.com/library/de...l/cDOpart1.asp

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

actually, correcting myself, CDONTS would be more appropiate
"BJ" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks!!!
I don't have any experience with CDONTS. I will look into it.

BJ