none
Importing Mainframe data to SSIS through Host integration server 2016. RRS feed

  • Question

  • Hi,

    I have installed HIS 2016 with VS 2015. Successfully able to create .HIDX file but was unable to move the data to SSIS ADO.net source. I don't have any idea how to give the right properties in the connection manager for Host file data provider.

    In the below screenshot i have tried importing a local Cobol copybook and it worked fine but when i try to give my mainframe credentials and test the connection the visual studio suddenly closes by itself. I'm not sure if i am using the right properties at the right place. Can someone help me in giving the right properties for the ado.net connection manager?

    • Edited by Chinna_1 Thursday, July 11, 2019 2:11 PM screenshot was not able to load
    Thursday, July 11, 2019 2:09 PM

All replies

  • Hi Chinna,

    I am also having same issue. Did you find any way to address these issue. If you have please share here which will help me too.


    Shaheen

    • Proposed as answer by Shaheen24s Wednesday, October 30, 2019 1:14 PM
    • Unproposed as answer by Shaheen24s Wednesday, October 30, 2019 1:14 PM
    Sunday, October 27, 2019 7:52 AM
  • please check my answer here below link.

    https://social.technet.microsoft.com/Forums/en-US/fce2d3cc-c221-4ab9-be17-1c747150786e/importing-from-mainframe-with-host-integration-server?forum=sqlintegrationservices


    Shaheen

    • Proposed as answer by Shaheen24s Wednesday, October 30, 2019 1:15 PM
    Wednesday, October 30, 2019 1:15 PM