I am trying to access data from As/400 system from SSIS.
I found that in many of the discussions, talking about creating a ADO.net Connection, then use Data reader source to access data.
I got BI Studio installed on a Windows 2000 professional system (SP 4).
But for creating an ADO.net connection, I am not able to find the driver 'Microsoft® OLE DB Provider for AS/400 and VSAM' in the drop down list.
I tried to create a DSN for this. But I am not able to find a Drive helping for it.
I got following doubts
1) Is this driver (Microsoft® OLE DB Provider for AS/400 and VSAM') available as a downloadable package? or Is it available in any other windows OS?
2) Is this the only way to connect AS/400 system from SSIS?
Can anyone please suggest me a solution for the above?