DTS job fails if scheduled on VB email step.
- From: "mutley1" <mutley1@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 03:58:02 -0800
Hi All,
I have a package that sends a mail using VB as opposed to sendmail (I'm no
expert on VB so apologies in advance). Basically it will retrieve the users
that match criteria, insert images and information and send the mail. This
works fine from DTS designer, but when run as a scheduled job, or using
windows scheduler and a batch file, it fails with the error below. Beginning
of VB code below. I have included line numbers as per the VB editor sees it.
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description: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 18
Error code: 800403FE
\Error Help File:sqldts80.hlp
Error Help Context ID:4500
I have seen numerous posts where no resolution was specifically found (for
my issue), but here's the answers to a few questions that I know I'll be
asked:
1. Outlook is installed on the server.
2. I am running the package when actually logged onto the server.
3. I am logged in as the SQL Agent domain account on the server.
4. The said domain account DOES have access to the outlook profile.
5. It works every time from DTS designer - only fails when scheduled via SQL
agent or Windows Scheduler.
6. Windows Server 2000 (SP3) and SQL 2000 (SP3), Outlook 2000.
CODE:
0'*****************************************************
1' Visual Basic ActiveX Script
2'*****************************************************
3
4Function Main()
5
6'create new Outlook MailItem
7 Set objApp = CreateObject("Outlook.Application")
8Set mapiNameSpace = objApp.GetNameSpace("MAPI")
9 Set l_Msg = objApp.CreateItem(olMailItem)
10
11' initialize CDO session
12 'Set oSession = CreateObject("MAPI.Session")
13 'oSession.Logon "xxxxxxx", "xxxxxxx", False, False
14
15'add graphic as attachment to Outlook message
16' change path to graphic as needed
17 Set colAttach = l_Msg.Attachments
18 Set l_Attach = colAttach.Add("C:\Program Files\picture.jpg")
19 l_Msg.Close olSave
20 strEntryID = l_Msg.EntryID
21 Set l_Msg = Nothing
22' *** POSITION CRITICAL *** you must dereference the
23' attachment objects before changing their properties
24' via CDO
25 Set colAttach = Nothing
26 Set l_Attach = Nothing
I believe that there is some kind of permissions issue when it tries to
insert the JPG into the mail as a scheduled job. As I say, it works when I am
logged in as the SQL Agent and Outlook is completely closed. I see an outlook
email window pop up briely on the screen (split second) when it creates the
mail. However, whenever it is scheduled via SQL or batch file, it fails.
Matt.
.
- Follow-Ups:
- Re: DTS job fails if scheduled on VB email step.
- From: Allan Mitchell
- Re: DTS job fails if scheduled on VB email step.
- Prev by Date: Changing source column at row by row base
- Next by Date: Re: DTS Error 22022
- Previous by thread: Changing source column at row by row base
- Next by thread: Re: DTS job fails if scheduled on VB email step.
- Index(es):
Relevant Pages
|
