Importing unstructured space-delimited flatfile
Hi I need a little help with importing a flatfile. I have multiple flatfiles (.dat) containing the following. #Parameter1: Show 10 steps (m2) 1 23.20 23.23 12.34 34.23 44.54 56.34 44.43 54.66 2 83.20 93.23 42.34 74.23 64.54 86.34 84.43 94.66 . . . 32 #Parameter2: Show 5 steps (cm2) 1 23.20 23.23 12.34 34.23 44.54 56.34 44.43 54.66 2 23.25 23.43 12.14 34.13 44.14 56.14 45.43 44.66 . . . 32 #Parameter3: ................... In total 9 parameters. If I choose Format "Delimited" and {LF} - in preview it shows up really nice. But, the headers is still inside the text. I need to locate each #Parameter and put the data in 9 different tables. It needs to transpose the data, so it goes in order like this; Having table called #Parameter1, with 1->32 as headers and the data under this. I'm new to SSIS, and I would like some tips on how to go on. //Jacob
September 7th, 2011 4:49am

I suggest to do this with a script component. Declare your FlatFile Configuration Manager as one row = one Column and do all other in the script component. You can create all outputs you need Maybe this Blog can help a little bit: http://www.bimonkey.com/2009/09/the-script-transformation-part-2-as-a-source/
Free Windows Admin Tool Kit Click here and download it now
September 7th, 2011 4:55am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics