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