SQLTeam.com | Weblogs | Forums

Assign Fixed Width to Conditional Split output

Is it possible to assign fixed width column names like we can do in Flat File Connection Manager>General> Format: Fixed width. >advanced

I have a Flat data source which doesn't have column names. What I have done is used a Conditional Split to divided data into relevant blocks. Each block now will have a fixed width column names. Is it possible to assign fixed width on output of Conditional Split like above image. I know I can use derived column and use SUBSTRING() to get values like shown in image 2. I have10 blocks and each block has around 20 column which i need to create a format for.