mainframe flat/sequential files to sql server

• alan dooley

  Valued Member

  Points: 73

  More actions

  November 15, 2004 at 9:06 am

  #65323

  I'm new to this forum.  Any help will be appreciated!  Trying to get an idea of how to bring in flat or sequential files that sit on a mainframe into sql server thru DTS. 

  I can convert 'em to db2 tables and bring in, but I really don't want to add that extra step .... unless of course I do not have a choice ....

  Thanks,

  Alan

• Fallen Angel

  Ten Centuries

  Points: 1128

  More actions

  November 15, 2004 at 6:52 pm

  #530208

  Do you have any tool to transfer the mainframe flat file to the NT Server?  Then using bcp or bulk copy to transfer the flat file into SQL Server.

• steven powell

  Mr or Mrs. 500

  Points: 557

  More actions

  November 16, 2004 at 12:10 pm

  #530329

  i've had pain with using DB2...

  you should be able to get the data out via ODBC then datapump it into SQLServer

  Good Luck!

• mimorr

  SSCarpal Tunnel

  Points: 4850

  More actions

  November 16, 2004 at 3:45 pm

  #530378

  I have found that I have to have software like VEDIT to convert the flat file from EBCDIC to ASCII before using DTS to bring the file to SQL.

  
  
  Michelle