Hello experts, In my internship i got a task and i need to use SSIS. I downloaded files from the "wether Station Center". The Data in these files is Arranged like this: see the sample of the data below 1)They ".txt" files 2)The whole content in each file is enclosed a "pre" tag i.e <pre>content</pre> 3)The Content: are actually table datas 5)Column delimiters are white spaces but they are not uniform 6)The Row delimiter is {CR}{LF} 7)Each table has the first row as a Tables description heading 8)and there is doted line separating the column names from the data rows 9) at the end of every row seem to be some redundant no printable characters too I have tried to extract the data using the FlatFile Task of ssis, but i could not succeed at determining the Row delimiter,removing the <pre> Tag(other than manually deleting it) and the last redundant non printable characters. I do not want to change the files manually before extraction, coz this would mean to much work (the files themselves are too many.) Question 1)With which ssis Task can i extract the data from the files and send them to the database and which confugurations do i need to apply to to this task The Sample of the data: <pre> Tageswerte der Station 10020 List auf Sylt STAT JJJJMMDD QN TG TN TM TX RFM FM FX SO NM RR PM ----- -------- -- ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ ------ 10020 20110607 1 11.8 12.4 13.5 15.1 88.3 2.0 7.5 1.0 7.9 0.0 1001.8 10020 20110606 1 13.1 13.2 16.4 21.3 90.5 3.0 11.3 2.7 7.1 0.0 999.2 10020 20110605 1 10.5 11.6 18.7 25.1 67.7 4.0 12.0 15.1 0.9 1.2 1008.7 10020 20110604 1 12.0 13.0 16.1 20.9 81.3 4.0 13.7 15.6 0.1 0.0 1020.2 10020 20110603 1 10.0 11.5 15.9 21.1 81.9 4.0 10.0 15.0 0.0 0.0 1029.4 </pre>