SSIS file with no deliminator, how(is it possible) to read using files source?

Question

I have got a feed (for Employee details) whose one record is like this.

101EnggAnal

brief given to me is 1st 3 characters will be employee ID, next 4 will be department and last 4 will be Designation. Can I read this using Flat file source? If yes how? Do i have to write Script Component as Source to get this done?

score 2 · Accepted Answer · answered Jul 09 '12 at 18:12

2

Unless I'm missing some nuance in your question, you are simply looking at a flat file connection manager with a format of Ragged right, or possibly Fixed width.

answered Jul 09 '12 at 18:12

billinkc

59,250
9
102
159

score 0 · Answer 2 · answered Jul 09 '12 at 11:14

0

I reckon the easiest way is to read it as one column, and in a Data Flow task use Derived Columns on the Source to generate the 3 columns you want via expressions before using those as the columns for the Destination.

answered Jul 09 '12 at 11:14

MartW

12,348
3
44
68

SSIS file with no deliminator, how(is it possible) to read using files source?

2 Answers2