Delimiting after initial connection

[Alan0568]

Hi all, I’m using 2008 SSIS and any help or suggestions with my project would be appreciated.

I have a delimited file source in which there are different types of rows (different column mappings). However the first four columns are uniform and allow me to identify what type of row it is and what I want to do with it.

Eg
1,2,3,A,red,10.56
4,5,6,B,1234598.78,London,456,blue,89.34,hiut,78,kl78,678
3,8,9,D,Greater Manchester,smith

My current thinking is that I’ll create a flat file source importing the whole row into a single column then use a conditional split to split the row based on a substring of the uniform first four columns.

The other consideration is that I need to retain (generate) a row number of the original file and pass this to all outputs from the split.

So firstly is this the right way to go and secondly relating to my post subject title how can I use the delimiter on the output of the conditional split? I’m kinda wanting the functionality of a flat file connection further down the chain.

Hope that makes sense.

Thanks in advance

 

[MDXer]

I would probably use a script task and create seperate outputs for the various record types. You can then assign your row id in the script as well.

What flat file fuctionality to you need later in your process?

 

[Alan0568]

Hi MDXer, thanks for the response.

I was thinking that my initial flat file connection would put everything in one row. I would then have a conditional split to separate the row types. How could I automatically use the "," delimiter on the rows *after* the conditional split in each of the outputs.

It turns out it was easier for me to write a small VB exe to handle this initial import,row id and separation of the rows. I'll just drop this in as a step in my SSIS package.

Thanks

A