sql server odbc: I am hoping to import a file exported from mainframe (packed decimal) into a
SQL Server database. Is it possible and if so, what is the best way to
accomplish this?

How is it exported from the mainframe? If it is exported
and out of the DB then it's no longer a packed decimal.
And thus, you can simply import the file into SQL Server.

You should also be able to do a direct "Import" in the SQL
Manager to get data from your MF into SQL tables. But you
need the ODBC drivers installed.

You can simplify this entire process though.

We connect to our AS/400 (which has packed decimal) fields
via the SQL Server which has Data Transformation Local
Packages which run Stored Procedures. We connect directly
to the AS/400 (SQL Server has the as400/iseries ODBC
drivers) and send and get information throughout the day.
Most of the legacy DB2 tables have packed decimal fields.

Of course you have to know how to program stored
procedures and Packages, but it automates the process
nicely.



[quoted text, click to view]