none
Importing a package with SMTP Connection Manager-SSIS 2017 RRS feed

  • Question

  • I am trying to import a package to SSIS 2017 .I have a SMTP connection manager in my package which is causing the issue while I import :

    OLE received a packet with an invalid extension. (Exception from HRESULT: 0x80010112) (Microsoft.SqlServer.DTSRuntimeWrap)

    I tried removing the connection manager and did an import. It worked.

    Can you please let me know if I am missing any assemblies?

    Monday, May 6, 2019 3:18 PM

All replies

  • You need to inspect the package for what name was used and whether it is the stock Send Mail task that uses a stock SMTP connection

    Arthur

    MyBlog


    Twitter

    Monday, May 6, 2019 3:55 PM
    Moderator
  • How and where to check that?

    can you please provide more info on this?


    Monday, May 6, 2019 8:59 PM
  • Hello, 

    Is that a built-in SMTP connection manager

    If yes, please create a demo package with SMTP Connection Manager and deploy it. 

    If the problem can be reproduced, please tell us which version of SSDT you are using and check the TargetServerVersion in the project. 


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Proposed as answer by Yang.Z Thursday, May 9, 2019 5:23 AM
    Tuesday, May 7, 2019 7:24 AM
  • I had similar issue. I have created sample package just with smtp connection with send mail task in control flow and executed pkg on studio which worked. But when I  tried to import package in ssms integration service 2017. Got same error message. I am using SSDT version 2017  15.9.11. Microsoft framework version 4.6.01055 and my targetserverversion is SQL server 2017.
    Tuesday, May 14, 2019 4:03 PM
  • Hi,

    With a new package with only a SMTP connection, the import failed.

    The TargetServerVersion is Sql Server 2017

    The SSDT version is :

    Microsoft SQL Server Data Tools para Visual Studio 2017  (SSDT)
    Versión 15.9.12
    VisualStudio.15.Release/15.9.12+28307.665
    Microsoft .NET Framework
    Versión 4.6.01586

    Versión instalada: Estándar IDE

    Microsoft Visual Studio Tools for Applications 2017   00371-40000-00001-AA979
    Microsoft Visual Studio Tools for Applications 2017

    Administrador de paquetes NuGet   4.6.0
    Administrador de paquetes NuGet de Visual Studio. Para obtener más información acerca de NuGet, visite http://docs.nuget.org/.

    Extensión ResourcePackage   1.0
    Detalles de la extensión ResourcePackage de Visual Studio

    Extensión ResourcePackage   1.0
    Detalles de la extensión ResourcePackage de Visual Studio

    Herramientas comunes de Windows Azure   1.10
    Ofrece servicios comunes para su uso con los servicios móviles de Microsoft Azure y Microsoft Azure Tools.

    Herramientas de C#   2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
    Componentes de C# que se usan en el IDE. Puede que se utilice una versión distinta del compilador en función de la configuración y del tipo de proyecto.

    Herramientas de Visual Basic   2.10.0-beta2-63501-03+b9fb1610c87cccc8ceb74a770dba261a58e39c4a
    Componentes de Visual Basic que se usan en el IDE. Puede que se utilice una versión distinta del compilador en función de la configuración y del tipo de proyecto.

    Paquete del host de adaptador de depuración de Visual Studio Code   1.0
    Capa de interoperabilidad para el hospedaje de adaptadores de depuración de Visual Studio Code en Visual Studio

    ProjectServicesPackage Extension   1.0
    ProjectServicesPackage Visual Studio Extension Detailed Info

    Proyecto   1.0
    Información acerca de mi paquete

    SQL Server Analysis Services   15.0.1300.108
    Diseñador de Microsoft SQL Server Analysis Services 
    Versión 15.0.1300.108

    SQL Server Data Tools   15.1.61903.01040
    Microsoft SQL Server Data Tools

    SQL Server Integration Services   15.0.1300.371
    Diseñador de MS SQL Server Integration Services 
    Versión 15.0.1300.371

    SQL Server Reporting Services   15.0.1300.108
    Diseñadores de MS SQL Server Reporting Services 
    Versión 15.0.1300.108

    SsmsVsIntegration   1.0
    Información acerca de mi paquete

    Wednesday, May 29, 2019 11:16 AM
  • Makes no sense what you are proposing here, please can you explain with more detail?
    Tuesday, October 1, 2019 1:48 PM
  • Having the same issue now and it's the beginning of October! Have you had any luck with this at all my friend?
    Tuesday, October 1, 2019 1:49 PM
  • Your question was answered and still no response from you? Please can you respond so we can get this component of SSIS working again, it's crazy you can't even send mail from a task now and what's even crazier is NO ONE is helping??
    Tuesday, October 1, 2019 1:52 PM
  • hey

    eamonn791

    Please be aware: you flagging replies that are not abusive is an abusive behaviour on your part.


    Arthur


    Tuesday, October 1, 2019 2:40 PM
    Moderator