DSXchange

set the delimiter in seq file as 'none'

check the odbc connection and try using join instead of look up.

how many rows u r getting in target dataset?

it is likely to be bad data what is the format u r giving in seq file

how many columns r u getting while importing meta data

hash partitioning would be a good choice

u can use this code in the transformer if it fits ur requirement Declare stage variables as follows: StageVar =DSLink3.No StageVar1 =StageVar<> StageVar1 StageVar2 =StageVar StageVar3 =DSLink3.Type:',':DSLink3.Name1:',': DSLink3.Name2 StageVar4 =IF StageVar2=1 then DSLink3.No:',': StageVar5 else Tri...

search for pivot or vertical pivot in the forum it will help u .

monitoring the memory while the process is running might help u to know where and y u r getting out of memory

Derivation field will be in transformer if u r using one.

check the ODBC connection

i think if u want to create more than one table u need more than one link for that means more than one ODBC stage .................

check the data types for the fields in source file

is it because the data stage not installed correctly?

modify operator means modify stage?