We have a SSIS job that archives reports, by scraping the attachment from the email and saving it to the appropriate folder.
I recently had to update my password, as part of our security policy. After I updated the password, I logged onto the server and updated the password in Task Scheduler. When I tried to update my account in Outlook (on the server) I discovered that IT has removed outlook....and replaced it with Office 365. No the timing of all this is strange, but basically everything was working fine on this SSIS job until I did the password change.
I've tried several troubleshooting measures....too many to list. My next question is this -
Do I have to change the vb script task to refer to Office 365 instead of "Outlook.Application.16"? If so, what do I change it to?
Partial Public Class ScriptMain
Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success
Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
Public Sub Main()
On Error GoTo ErrorHandler
Dim bt(0) As Byte
Dim myOlapp As Outlook.Application
Dim myNameSpace As Outlook.NameSpace
Dim myItem As Outlook.MailItem
Dim myAttachment As Outlook.Attachment
Dim vFolder As Outlook.MAPIFolder
Dim oDestFolder As Outlook.MAPIFolder
myOlapp = CType(CreateObject("Outlook.Application.16"), Outlook.Application)
myNameSpace = myOlapp.GetNamespace("MAPI")
......more script below this.
Any help is most appreciated....this is causing me to pull my hair out 🙁