Post reply

Cannot load MAPI interface layer for DTS. Please make sure that semmap.dll is installed.

  • December 22, 2006 at 1:43 am

    #68122

    I’m getting an error when trying to create/use a “send mail task” in dts(data transformation service) package.

    Error description: Cannot load MAPI interface layer for DTS. Please make sure that semmap.dll is installed

     

    I have SQl 2000 standard installed

  • December 22, 2006 at 2:14 am

    #679666

    Hi

    Need to load the outlook, Create profile for sending mail

     

     

  • December 22, 2006 at 2:33 am

    #679669

    Hi Wayne

    Outlook is configured already for sending mail

  • December 22, 2006 at 7:41 am

    #679718

    Consider switching to this:

    http://www.sqldev.net/xp/xpsmtp.htm

    Replace Send Mail tasks with Exec SQL tasks that call the xp_smtp_sendmail stored proc. SQL Mail with Outlook in Sql 2000 is horrible. We finally threw in the towel. Would work fine for months, then after an Outlook security pacth, we'd be losing days diagnosing & figuring out why emails were going down a black hole or hanging xp_sendmail calls.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply