Import Non delimited Text File SSIS

Question

0.00/5 (No votes)

See more:

, +

I have text files with the below format:

89898 ABCF-ASDAS 23.88
45334 MJKI-OP MKLDFMK 89.88

How to read from the above format using flat file source connection? which parameters I can use to read the above formatted file? Help needed.

Posted 28-Sep-15 0:47am

Jaya Shanmuga Pandian Srinivasan

Updated 28-Sep-15 1:42am

v3

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 12016701 · Answer 1 · 2015-09-28T01:17:00

Solution 1

Assuming the only time the space character can be used as the delimiter you can read your flat file one line at a time, then split by Space

C#

using (StreamReader sr = File.OpenText(Filepath)) //<-- Filepath here
                {
                    string line = String.Empty;
                    while ((line = sr.ReadLine()) != null)
                    {
     
                  
                        //split by SPACE
                        string[] values = line.Split(' ');
                MessageBox.Show(values[0]) // first time round would return 89898 
                MessageBox.Show(values[1]) // first time round would return ABCF-ASDAS
                MessageBox.Show(values[2]) // first time round would return 23.88      
  
                    }

Posted 28-Sep-15 1:17am

Member 12016701

Updated 28-Sep-15 1:18am

v2

Comments

Jaya Shanmuga Pandian Srinivasan 28-Sep-15 7:39am

In some cases there are names with spaces in between them. For ex: ABCF ASDAS Instead of ABCF-ASDAS. What can I do for those values?

Member 12016701 28-Sep-15 8:14am

Is the 3rd value always a number? If so you could check if values[2] is a number...

using (StreamReader sr = File.OpenText(Filepath)) //<-- Filepath here
{
string line = String.Empty;
while ((line = sr.ReadLine()) != null)
{

//split by SPACE
string[] values = line.Split(' ');
decimal d;
bool isNumeric = Decimal.TryParse([values[2], out d);
if (isNumeric)
{
MessageBox.Show(values[0]);
MessageBox.Show(values[1]);
MessageBox.Show(values[2]);
}
else
{
MessageBox.Show(values[0]);
MessageBox.Show(values[1] + " " + values[2]);
MessageBox.Show(values[3]);
}
}
}

Not tested this yet

Import Non delimited Text File SSIS

1 solution

Solution 1

Add your solution here

Preview 0

Import Non delimited Text File SSIS

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us