How to use set row and column delimiter in flat file connection manager editor

2
votes

I am trying to set row and column delimiters for flat file connection manager here the data i have The data is in .txt file 

"Det.ID","Cus.ID","SHIP.ID","PRODUCT"----columns
"BO861"00184490"0000"09530-2"TARASCON "   ---- rows

For rows how to set the row delimiter for this kind of separator 

"BO861"00184490"0000"09530-2"TARASCON "
1
csvssisetlflat-file

1 Answers

0
votes

I don't think you will find a optimal solution to read a similar file from Flat File Connection Manager, in a similar case i will do the following steps:

  1. Add a Flat File Connection Manager
  2. Ignore first Row
  3. Uncheck reading header from first row option

enter image description here

  1. Add 6 Columns (based on rows) manually from Advanced Tab and change columns names as wanted

enter image description here

  1. Go to Columns Tab and change the columns delimiter to "

enter image description here