We require a contractor to develop PERL code that will parse and upload the following example file to a SQL Server 2008 R2 instance. The database design is required for this project and must be normalized to minimize redundancy (i.e., multiple tables with unique IDs and foreign keys). We will import many files of this type so the code must obtain and assign unique IDs. Database design must also incorporate appropriate indexes.
The example file may be accessed through the vendor's FTP server site at:
<ftp://[url removed, login to view]>.
It is located within the compressed TAR file named: GS19240-1100-36-ASM-VAR-files.tar. Once extracted, follow the directory structure below:
Extract the compressed BZ2 file named: var-GS19240-1100-36-ASM.tsv.bz2. The table contains the header rows which must be contained in one or more separate tables.