Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Import Fixed Width Multiple Record text files into SQL Server

Import Fixed Width Multiple Record text files into SQL Server 8 years 1 month ago #2721

  • Derrick
  • Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 8
  • Thank you received: 0
Can your Advanced ETL Processor Pro import Fixed Width Multiple Record text files into SQL Server?

We have a very large legacy extract that we need to import into SQL Server 2005/2008. The files are approximately 2GB. There are 7 different record types each with its own field formatting e.g.

Record Type 01

01105ALAMANCE 2008CRS065589 etc,

RecordType 02
02Smith,Paul,Anthony

RecordType 03
03015441TNO OPERATORS LICENSE

RecordType 04
04JONES,C,G SHP etc,

RecordType 05
0502 120D C012MY0000 etc,

RecordType 06
0601ATTY FEE $75;PAY ON SCH OF P/O;STAND etc,

We need to either import these files into a SQL staging table and then extract and insert them into the proper parent/child tables or have the ETL Tool import them into the proper parent/child tables.
Every 01 RecordType is the parent and the record types 02 - 06 are the child records. There is a one-to-many relationship between the 01 RecordType and the 02-06 Record types.

Can you tool handle this type of import?

Derrik

Please Log in or Create an account to join the conversation.

Re: Import Fixed Width Multiple Record text files into SQL Server 8 years 1 month ago #2722

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7540
  • Karma: 33
  • Thank you received: 412
It is not straight forward but it is possible

You would need to use keep value function + previous record function

If you are struggling email support sample of your file and they will assist you

Peter
Mike

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 181 guests and 2 members online