asranantha (8/27/2012)

---

hi friend i have a small doubt in ssis plz tell me how to solve this prob

all columns are separete with $ symbole

flat file soure data like columns are 1000 no of columns i given some sample columns like this

ab $ 1234 $ xyz $678

1 $ 100 $5000$258

2 $ 2500 $3600$356

3 $36500 $ 35200$147

[highlight=#ffff11]so this data load into database tables.

here first load ab columns data once load ab data then it will be truncate before load 1234 columns data once load 1234 columns data it will be truncate before load xyz columns data like this way we do what ever columns in flat filses we do same way.[/highlight]

plz tell me what logic we apply here

i do like this way i taken sequencce container in controlflow lever and taken 4 dataflow tasks in 4 dft bottom i taken 4 execute sql tasks

dft1 i cofigrure flat file sourece and i select requerd column in 1st table that is ab columns and configure to destingation table .and dft1 bottome i taken execute sql task that time i write query truncate table tablename.

like this way i do remain three columns.

but here flat file source contains so many columns .

how we do dynamicaly load and truncate .plz tell me