<div>
Could you please post a sample of the text file? &nbsp;One (usually) straightforward way to do this is write a script (perhaps in VBscript or something equivalent) to parse the data from the text file and insert the data into the sql table(s).<br />
<br />
If you upload a sample file, be sure to specify the rules for parsing it including the sql table names, columns and data types.
</div>


Could you please post a sample of the text file?  One (usually) straightforward way to do this is write a script (perhaps in VBscript or something equivalent) to parse the data from the text file and insert the data into the sql table(s).

If you upload a sample file, be sure to specify the rules for parsing it including the sql table names, columns and data types.


Test.txt [https://filedb.experts-exchange.com/incoming/2017/02_w06/1144078/Test.txt]

Test.txt

<div>
A SSIS package was the answer as some data elements were missing or corrupt and some needed fixing, it was a much faster method.
</div>


A SSIS package was the answer as some data elements were missing or corrupt and some needed fixing, it was a much faster method.

<div>
<div class="content wysiwyg-content">
I need to read a text file and insert specific values into a table in sql server, I have the starting position and length of fields I need to read from the text file, but I needs some hints on how to go about parsing and selecting the desired values.<br />
<br />
Your thoughts.<br />
Thx
</div>
</div>


I need to read a text file and insert specific values into a table in sql server, I have the starting position and length of fields I need to read from the text file, but I needs some hints on how to go about parsing and selecting the desired values.

Your thoughts.
Thx

Text file into sql server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.