"Roy Harvey" wrote:

> If the system is running OS/400 something should be possible, but I do
> not know if you will find it too complicated or not. The approach I
> would take is to extract the data to flat files of readable text. No
> packed data, no "overpunches" to indicate sign, just readable text.
> Then you need to transfer the files to a Windows box using some tool
> that convertes the EBCDIC characters to ASCII. Then it can be
> imported into SQL Server.
>
> Setting this up to be a production process with current data on some
> refresh schedule is a fair bit of work, but once you have an approach
> that works it isn't that big a deal to do again.
>
> If it is not running OS/400 it may actually be easier, but I know
> nothing about the alternatives.
>
> Roy Harvey
> Beacon Falls, CT
>
> On Thu, 16 Aug 2007 18:05:39 -0700, Jay
> <Jay@discussions.microsoft.com> wrote:
>
> >I am being asked by a banker if their loan accounting system data can be
> >imported into SQL server. The LAS system is on a IBM iSeries platform. Is
> >this something that can probably be imported into a SQL Server database or is
> >this something that will likely be very difficult. The reason to bring the
> >data into SQL server is to develop ad-hoc reporting and the ability to add
> >additional data that is not in the loan system. Does anyone have any idea
> >what I can do or how I should pursue this.
> >
> >Thank you