Home » SQL ServerRSS

How to read data from vsam files also

i want to know how can i use vsam(virtual storage access method) files.... i heard that we have to install attunity software... is it right?.. and can any one will tell me the exact procedure how i can use vsam files in ssis... and  vsam is nothing but VSAM (Virtual Storage Access Method ) is an access method for IBM's mainframe operating system, MVS, now called z/OS..

so if any one have any idea about this then plz let me know..

 

5 Answers Found

 

Answer 1

Hi Priyanka,

You may try using OLE DB provider for AS400 and VSAM to access VSAM. For more infomation, please see:
http://msdn.microsoft.com/en-us/library/ee266720(BTS.10).aspx

Thanks,
Jin Chen

 

Answer 2

thankx for the reply :)

do we have to install some software so that we can get the access to this vsam files?? if so which are those??

i have browsed over net and there i got the information like we should have something called as Z OS.. which is from attunity..

and do we have to change the framework???

if u get any information then plz let me knw...

 

 

Answer 3

thankx for the reply :)

do we have to install some software so that we can get the access to this vsam files?? if so which are those??

i have browsed over net and there i got the information like we should have something called as Z OS.. which is from attunity..

and do we have to change the framework???

if u get any information then plz let me knw...

 


Priyanka.Sutrave
Did you check the link Jin sent you? It contains all information you need. You have to install Microsoft Host Integration Server 2004 to have VSAM drivers available for use in SSIS.
 

Answer 4

I got a new assignment in South africa .In which i need to extract VSAM files(low volume) to MIS server(SQL server 2005) using SSIS.To let you know i am not mainframe resource or SSIS .I have experince of Informatica(ETL) tool so i can manage SSIS .Kindly let me know the way to goahead .

 

Answer 5

I got a new assignment in South africa .In which i need to extract VSAM files(low volume) to MIS server(SQL server 2005) using SSIS.To let you know i am not mainframe resource or SSIS .I have experince of Informatica(ETL) tool so i can manage SSIS .Kindly let me know the way to goahead .
 
 
 

<< Previous      Next >>


Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter