Search code examples
ssisflat-filefixed-width

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

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?

Solution

  • 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.