I've started learning SSIS and I'd like to replace our import tool with an
SSIS project. The data warehouse is populated from flat files (fixed width
format) - there are a handful of different formats and all the files are
quite wide ~300 columns. I already have custom format files used by our
current import tool - these are stored as csv files that specify column
names, start, end and length of each column. e.g.
; Comments at start of file starting with a semi-colon
columnname, start, end, length
MyColumnName, 1, 2, 2
MyColumnName2, 3, 6, 4
Is there an easy method to create a flat file connection from these format
files? It would be time consuming to create these by hand - Is there an easy
way to create these connections. I know you can create custom data sources -
the existing flat file data source is fine, but an easy method to enter the
specification would be useful.