I am very new in working with SSIS. I would like to create a package that would take a series of flat files and convert some of the information into a new delimited flat file. Flat file to flat file; I don't need to import into or extract out of a database.
Below is a small sample of what the source file looks like. As you can see, this file is broken down into sections; there are header records (noted by '[' and ']'), and detail rows underneath the header record. However, some header records contain data that corresponds with the header record itself. For example, the 'ECONV' header record contains a 'GLLoadEnt' record with detail following it. The rows beneath this header record correspond with the 'GLLoadEnt' record. Theoretically, there could be multiple 'ECONV' header records, and the rows following each header record all correspond with the preceding header.
Columns are delimited using the '!' character.
I have written VB.NET code that takes this flat file and can import the information into a database, but I am researching the possibility of using SSIS. I would appreciate any advice as to my approach. If this is going to be too complex for SSIS, I would want to know that.
Any and all help would be greatly appreciated!
Geographic !Geographic Consolidation !MAXIMUM !Geographical
Function !Function Consolidation !MAXIMUM !Function
LC !Local Currency !MAXIMUM !LCTop
[ECONV=GLLoadEnt !GL Load for Entities !MAXIMUM !L]
[ENTITYLIST=AllEnt !All Entitities w/o Subs !MAXIMUM !D]