asked
How to read data from VSAM files of IBM mainframe with SSIS and store it as relational data in SQL Server?
Hi Everyone, I am working on a task to extract data from a bunch of VSAM files from IBM Mainframe and store it into SQL Server as relational data, I found that in many of the discussions, talking about creating a
ADO.net Connection with
ADO.NET Data Provider for Host Files, then use Data reader source to access data, but I am not able to find the driver(
ADO.NET Data Provider for Host Files) in drop downlist when creating the
ADO.net Connection. I also can't find the provider in SQL Server 2012 SP1 Feature Pack, where can I download the provider without installing HIS 2013?
Are you wanting to stay away from installing a 3rd Party driver? If so, then I'm not sure it is going to be possible. I currently use SSIS to communicate with an iSeries (IBM) platform and this requires its own ODBC/ADO driver. On searching there are a couple of providers out there, but I can not comment on their reliability [
http://www.attunity.com/products/attunity-connect/vsam-data-access][1] [
http://www.connx.com/products/database_drivers.html] [2] [1]:
http://www.attunity.com/products/attunity-connect/vsam-data-access [2]:
http://www.connx.com/products/database_drivers.html
15 People are following this question.
