Load EBCDIC data from text file

I am receiving a data file in EBCDIC format via FTP.  I need to load the data into SQL Server tables.  What tools/techniques can I use to accomplish this?
Who is Participating?
Scott PletcherConnect With a Mentor Senior DBACommented:
Have the FTP from the mainframe automatically convert the file to ASCII.  That should be possible, and if you can do it on the mainframe side, it will be very fast.
Scott PletcherSenior DBACommented:
There is plenty of software external to SQL Server that can convert EBCDIC to ASCII.  

In fact, most mainframe and AS/400 (two main sources of EBCDIC data, I suspect) transfer tools have an option to automatically convert for you during transfer.

I would definitely look into methods outside of SQL Server rather than trying to do something within SQL.
What is the source of the data?

Are you using FTP to retrieve the data from an AS400?  There may be other options, ie ODBC which will convert the data for you.
KSleeperAuthor Commented:
The data is being delivered via FTP by the mainframe.    At this point, I only have a text file (in EBCDIC format) to work with.
All Courses

From novice to tech pro — start learning today.