DSXchange

Use the Sequential File Stage. Specify first line is column names.
Use the rowcount property to read first N rows.
use before job routine to count the number of rows in a file.
N-1 Pass this value as Rowcount Parameter.

Convert The Filed Mark Value in a user variable activity

Read as a Single Column then check for the length and extract the Columns by using substring Function. Totally in Transformer define 6 Columns Column1 SingleColumn[1,5] Column2 If Len(SingleColumn)=30 Then SingleColumn[6,9] Else SingleColumn[6,8] and so on for other columns. This code is as per the ...

Why not define Reference Table for all Combinations. Key Value 200 100 300 100 400 100 600 500 700 500 1000 900 1100 900 Field(InputData,':',2)--Output of this to be used to Lookup in Reference Table(Key Column).

May be ODBC Stage has Both Generated Query as well as User defined query.
Check and Correct.

Try to create two temp file one with 30 bytes and another with 33 bytes

awk 'length>30' Filename > 30byteFilename_temp(your Convenient)

awk 'length=30' Filename > 33byteFilename_temp(your Convenient)

Try the schema Definitions.

Enable the multiple instance invoke the same job for Various file formats.
Store the schema file infile systems.invoke the schema file through parameter.

try

dsjob -linvocations Projectname jobname

i can see There is no record type field in your file.

Usually REC_TYPE is one byte.
Modify the file accordingly.Define in Columns tab Char=1

As Ray adviced If you specify the Datatype = Char
we shoud not specify this option record length = fixed.since char is fixed length datatype.

Just define final delimiter = end.

and remove the delimiter property.i.e Delimiter=Comma

what is length for the header.

Header length should same as Other Records length.
try import through sequential file definitions.

Set First Line is Column Name=True. Record Length = Fixed Record Delimiter = UNIX New Line. CASDC142585654DAFSD74586KDJMEN CASDC142585655DAFSD74586KDJMEN CASDC142585656DAFSD74586KDJMEN CASDC142585657DAFSD74586KDJMEN CASDC142585658DAFSD74586KDJMEN CASDC142585659DAFSD74586KDJMEN CASDC142585660DAFSD745...

Sort The Year by using sort stage. And in Transformer Stage define

Svyear(Initial Variable '0')
--------------------



SvF1(Initial Variable '0')
-------------------- i haven't tested the code.

Read all the columns from file and then map only the columns that you want in transformer stage.

Trim the field when extracting from table itself.
Or have a transformer before dataset and do the null handling.

You have to make sure the Field Value length must be less then the Column length.