sql server integration services importing 2 tsv : <p>I have two .tsv files and I need to import them to sql server: one has the data (data.tsv) and the other is column_headers.tsv</p>

<p>I need to import it to a table, the table must be created with column_headers.tsv columns and the data.tsv should be inserted to that table.</p>

<p>I will need to do this a few times, so I would like to automate it… Can I achieve this with SSIS?</p>

<p>is there a standard process on how to import data to sql server using 2 tsv files: data.tsv and column_headers.tsv ? is there a standard process on how to create tables based on column names provided from a .tsv?</p>

<p>I know nothing about the data itself… Extra information I have for the data:</p>

<p>Datafeed-Manifest-Version: 1.0</p>

<p>Lookup-Files: 1</p>

<p>Data-Files: 1</p>

<p>Total-Records: 18,584</p>

<p>Lookup-File: c-it_2016-09-30-lookup_data.tar.gz</p>

<p>MD5-Digest: 7efa8c4e901bb666</p>

<p>File-Size: 3663715</p>

<p>Data-File: c-it_2016-09-30.tsv.gz</p>

<p>MD5-Digest: 6ece62faaaaa084f8a3d73b55</p>

<p>File-Size: 1066972</p>

<p>Record-Count: 18,584</p>
