Loading for 6th Record

In case of flat file I dont want to load first 5 rows in the target? It must load from the 6th record. Can anyone help me out.

NOTE : [I][This question was asked by Vinoth] [/I]

then put the number 5 when u import the file, the designer will ask no. of rows to skip.
there givn 5 .it will skip 5 rows and start loading from 6 row.

Hi,

Logic
------

SRC----EXP-----FIL------TGT

In expression create one varaible port(V_SEQ_NO)

STEP 1: Write this expresssion in variable pt->
IF(ISNULL(V_SEQ_NO),1,V_SEQ_NO+1)
STEP 2: Pass this port to FILTER
STEP 3: In Filter condition, V_SEQ_NO = 6

Please get back to me in case of queries.

Thx & Regards,
Prakash

[QUOTE=JobHelper;7594]In case of flat file I dont want to load first 5 rows in the target? It must load from the 6th record. Can anyone help me out.

NOTE : [I][This question was asked by Vinoth] [/I][/QUOTE]

take filter after s.q and filter first five records.

[QUOTE=JobHelper;7594]In case of flat file I dont want to load first 5 rows in the target? It must load from the 6th record. Can anyone help me out.

NOTE : [I][This question was asked by Vinoth] [/I][/QUOTE]

take expression transformation in that generate sequence by usin variables after that put filter and filter first five records.

[QUOTE=chiru4015;32165]take filter after s.q and filter first five records.[/QUOTE]

With what [COLOR="Red"]Chiru........! [/COLOR]:mad:

Please follow the step given by [B][COLOR="SeaGreen"]cme_prak[/COLOR][/B]