SSIS for Fixed Length line
-
I have a file in which each line has a fixed length 1600 char but each line has its there are different columns Line 1 will be like this RA01XYZ--------------------------------------------------------------------201401231 RA is Record Type 01 is Version XYZ------------------ is client name 201401231 is date now 2 line SR0123456789-------------------------011234567890- SR is record type 0123456789------------------------- is some number You see that each line will have its own set of defined columns and it cannot be fixed width So my question is, is it possible/advisable to apply SSIS on this or create a simple win form application using REGEX to extract and process the data.
-
I have a file in which each line has a fixed length 1600 char but each line has its there are different columns Line 1 will be like this RA01XYZ--------------------------------------------------------------------201401231 RA is Record Type 01 is Version XYZ------------------ is client name 201401231 is date now 2 line SR0123456789-------------------------011234567890- SR is record type 0123456789------------------------- is some number You see that each line will have its own set of defined columns and it cannot be fixed width So my question is, is it possible/advisable to apply SSIS on this or create a simple win form application using REGEX to extract and process the data.
Regex? No, Substring(start, length). Read a whole line, determine the "line type", and then get its data into appropriate objects which you then insert into the db.
-
Regex? No, Substring(start, length). Read a whole line, determine the "line type", and then get its data into appropriate objects which you then insert into the db.
Bernhard Hiller wrote:
get its data into appropriate objects
Which he may do by using an appropriate regex, so not a really bad start.
Clean-up crew needed, grammar spill... - Nagy Vilmos
-
Regex? No, Substring(start, length). Read a whole line, determine the "line type", and then get its data into appropriate objects which you then insert into the db.