sql server dts: Is there an easy way to migrate the mainframe databases, e.g.
ServiceCenter P4 or Model 204 to SQL Server. In general, they all can
be called relational databases, but the data can not be migrated easily
by using the database utility tools. Other than transfering to text or
Excel, then to SQL Server, are there any easy ways to do the direct
migration?

Thanks in advance,
Jeffrey

My experience is that as well as 'migrating' the data, there is often a lot
of data cleanup, standardization, and conforming that needs to be done. So
my approach is to dump into text files, load them into 'Staging' tables, run
whatever cleanup, standardization, and conforming scripts are necessary, and
then move the data to the production tables. This will have to be done many,
many times in order to fine tune the scripts.

Could be a 'fair' amount of effort -but in a legacy, mission critical
situation, often necessary.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]