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.
| Author |
Topic |
|
tn717
Starting Member
4 Posts |
 Posted - 2003-09-08 : 14:39:43
|
| I'm getting a problem with running a DTS Package from the Scheduler.The Package contains a single VB Executable. When I execute the package from the DTS Viewer/Menu or Running the DTSRUN Command line script... the everything works fine. If the job runs from the scheduler I get an error raise in my VB App.-2009857790: Could not complete the operation because the service provider does not support it.The error is occuring in a module that sends email to a specified user using an Outlook/MAPI profile.Any thoughts? I looked up this problem on MS Support and only found 1 article that even came remotely close. The solution was to click the "Execute on main Pack thread" option from work flow and to log the error. This did absolutely nothing and no errors were logged in the package logs.Help on this would be greatly appreciated. Thanks ~TN |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-08 : 14:47:12
|
| The e-mail is being sent using the account that the SQLSERVERAGENT is running under. Does this account have a MAPI profile?Tara |
 |
|
|
tn717
Starting Member
4 Posts |
Posted - 2003-09-08 : 18:30:05
|
| Well Crap... Nevermind. Thanks Anyway. It looks like it is an Outlook issue and not a problem with DTS or SQL Server Agent.In case any body was curious. Here's where I found the information.Microsoft.public.vb.com:>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>Message 2 in thread From: Nick Huang (nickhuonline@microsoft.com)Subject: RE: Problem with call Component in Component Services View this article only Newsgroups: microsoft.public.vb.comDate: 2001-07-30 23:59:55 PST Hi,The Outlook Object Model is not suitable for use in a server component. For example, in a NT service, ASP and MTS (COM+). For detailed information, please refer to the following KB article.Q237913 INFO: Outlook Object Model Unsuitable to Run in Windows Servicehttp://support.microsoft.com/support/kb/articles/q237/9/13.aspIn such cases, I suggest you use CDO or CDONTS instead. For your references, below are some links to CDO sample codes.Q244587 SAMPLE: Cdoasp.exe Creates Simple Mail Client Using CDO and ASPhttp://support.microsoft.com/support/kb/articles/q244/5/87.aspQ177851 HOWTO:Build CDO (1.x) Messaging Application to Run from Servicehttp://support.microsoft.com/support/kb/articles/q177/8/51.aspQ176916 - INFO: Active Messaging and Collaboration Data Objects (CDO) http://support.microsoft.com/support/kb/articles/q176/9/16.asp Regards,Nick |
|
|
|
|
|
|
DTS Errors from scheduler