we can write the shell script for it
we call it either in command task or pre and post session shell commands in session
using Aggregator trans FIRST and LAST funtions we can pass first and last record
Design a mapping to load the first record from a flat file into one table A, the last record from a flat file into table B and the remaining records into table C?
If session fails after loading 10000 records in the target, how can we load 10001 the record when we run the session in the next time?