Results 1 to 3 of 3

Thread: Convert flat file to SQL 2000

  1. 10-14-2003, 12:34 PM #1
    majorbroncosfan
    majorbroncosfan is offline Registered User
    Join Date
    Aug 2003
    Posts
    15

    Convert flat file to SQL 2000

    I have a table in a flat file that I need to convert to SQL Server 2000. Within this file are 4 different record definitions (all are similar but with different lengths).

    I have experience converting files that are of 2 different record definitions, but never with this many. What kind of data migration techniques are available for such a process? I need to be able to get these 4 different definitions into 4 different tables.

    It is coming from a COBOL program in UNIX.

    Any help would be greatly appreciated.
    Reply With Quote Reply With Quote
  2. 10-14-2003, 01:25 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    store the entire flat file in to a temp table and then separate it using procedure.
    Reply With Quote Reply With Quote
  3. 10-14-2003, 06:41 PM #3
    majorbroncosfan
    majorbroncosfan is offline Registered User
    Join Date
    Aug 2003
    Posts
    15
    Thank you for your reply.

    I did try that, but if I parse it in DTS, it simply does not parse it correctly.

    I will try it a different way to see if it works.

    Thanks again!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules