Share via

Managed provider for Host files - programmer's guide

  • Article

New to Microsoft's Managed Provider for accessing VSAM files and AS400 file system ?

Here is a compile of material that can be helpful for the first time users :

Product documentation for programmers:

https://msdn2.microsoft.com/en-us/library/aa771659.aspx

https://msdn2.microsoft.com/en-us/library/microsoft.hostintegration.mshostfileclient.aspx

How to define the mapping for VSAM files and AS400 files ?

https://technet.microsoft.com/en-us/library/aa771286.aspx

If you are upgrading from existing HIS server to HIS 2006, Host file provider is one of the reasons.

https://www.microsoft.com/hiserver/evaluation/overview/topreasons.mspx

Here is the help for SQL Queries :

https://blogs.msdn.com/asmitaw/archive/2007/05/02/mshostfileclient-sql-syntax.aspx

SQL Server integration  Services :

We can actually Import / export data from Host file provider and also Data flow packages can be created in programmatic to fetch data from the VSAM files and AS400 files .

link to SQL SSIS :

https://www.microsoft.com/sql/technologies/integration/default.mspx  AND

 I am looking forward to myself for adding a sample which will describe SSIS with MSHostfileClient.