Load Ingest Data
Page 1 of 2 12 LastLast
Results 1 to 10 of 20
Like Tree2Likes

Thread: Attunity SSIS connector support for Sql Server 2014?

  1. #1
    VERCELLI is offline Junior Member
    Join Date
    Apr 2014
    Posts
    3
    Rep Power
    0

    Attunity SSIS connector support for Sql Server 2014?

    Hello,

    We've been successfully using Attunity SSIS connector 2.0 for a couple of years with SQL SERVER 2012.
    We developed some Visual Studio projects and deployed them on our SSISDB. Then launch them with scheduled jobs. Everything worked fine.

    After we upgraded the server to Sql Server 2014 the connector failed with the following error:
    The connection type "MSORA" specified for connection manager "XXX" is not recognized as a valid connection manager type.
    This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.

    We tried uninstall/install but was no good. Also 32/64 bits combinations.
    We tried DTEXEC utility and worked fine on sqlserver 2012 folder ( \110\DTS\Binn) but didn't work on 2014's folder ( \120\DTS\Binn).
    We also tried a fresh 2014 installation but keep getting the same error.

    Does Attunity connector 2.0 support Sql Server 2014? If not, should I wait for a new version? Any workaround?
    For now, we are using the DTEXEC utility on 2012's folder, but since we have to use the /sql option (/ISSERVER is not working) we can't pass parameters to the .dtsx package.

    Any help would be much appreciated.

    Regards,
    Daniel

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Daniel,

    The Microsoft SSIS Oracle and Teradata Connectors version 2.0 do not support SQL Server 2014. A new version of the connectors will be released latter this year that will support SQL Server 2014.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    VERCELLI is offline Junior Member
    Join Date
    Apr 2014
    Posts
    3
    Rep Power
    0
    Thank you very much Gadi.

  4. #4
    stegus is offline Junior Member
    Join Date
    Jun 2014
    Posts
    1
    Rep Power
    0
    Quote Originally Posted by Gadi.Farhat View Post

    The Microsoft SSIS Oracle and Teradata Connectors version 2.0 do not support SQL Server 2014. A new version of the connectors will be released latter this year that will support SQL Server 2014.
    Do you have any more information about when this version will be released?

    /Stefan

  5. #5
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi Stefan,
    The decision and timeframe in which the connectors will be released for SQL Server 2014 are at Microsoft's discretion and cannot provide more information at this time.


    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  6. #6
    robert.caretta@rusd.org is offline Junior Member
    Join Date
    Jun 2014
    Posts
    3
    Rep Power
    0
    +1 for me on this topic, this is needed.

  7. #7
    Mike Honey is offline Junior Member
    Join Date
    Aug 2012
    Posts
    5
    Rep Power
    0
    Several months have passed with seemingly no progress on this?

    +1 from me too - I have multiple clients holding off on SQL 2014 upgrades due to this issue.

  8. #8
    robert.caretta@rusd.org is offline Junior Member
    Join Date
    Jun 2014
    Posts
    3
    Rep Power
    0
    Quote Originally Posted by Gadi.Farhat View Post
    Hi Stefan,
    The decision and timeframe in which the connectors will be released for SQL Server 2014 are at Microsoft's discretion and cannot provide more information at this time.
    Regards,
    Gadi
    We still need the SSIS attunity adapters please... we have a package that can not be upgraded.

    For those of you that have not seen this, here are some links related to SQL Server 2014 CDC:
    - Download Microsoft® SQL Server® 2014 Feature Pack from Official Microsoft Download Center
    - Change Data Capture Service for Oracle by Attunity F1 Help
    - CDC Flow Components
    - CDC Flow Components
    - CDC for Oracle in SQL Server 2012 - SSIS Team Blog - Site Home - MSDN Blogs (2012 documentation)

  9. #9
    Henrik Staun Poulsen is offline Junior Member
    Join Date
    Aug 2014
    Posts
    1
    Rep Power
    0

    any news on this?

    Hi Gadi,

    We need to plan for the upgrade of our SQL Servers, and we need a date for the release of your driver.
    If we cannot get this, we will be forced to look for a work-a-round solution that does not involve Attunity.

    Best regards,
    Henrik



    Quote Originally Posted by Gadi.Farhat View Post
    Hi Daniel,

    The Microsoft SSIS Oracle and Teradata Connectors version 2.0 do not support SQL Server 2014. A new version of the connectors will be released latter this year that will support SQL Server 2014.


    Regards,

    Gadi

  10. #10
    robert.caretta@rusd.org is offline Junior Member
    Join Date
    Jun 2014
    Posts
    3
    Rep Power
    0

    Bump

    Bump......

Page 1 of 2 12 LastLast

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •