How to load data from multiple txt files after removing first row into tables?

Ramana Kopparapu 306 Reputation points
2024-11-23T07:58:05.68+00:00

Hi All,

I faced one scenario where i have 6 txt files of different regions. In every text document First Line is not required. How can I remove First line alone and load the data from all six source docs into SQL tables?

Data From North Region

id|name|age|sal

101|ABC|36|2000

102|DEF|38|2500

103|GHI|32|2500

Data From North Region is the first line in this document. Like that I have 6 docs.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,601 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.