sql server - Tilde (~) Delimited File Read in SSIS -

sql server - Tilde (~) Delimited File Read in SSIS -

i'm trying load tilde (~) delimited .dat sql server db using ssis. when utilize flat file source read file, don't see alternative of ~ delimiter. i'm pasting row file below:

7318~97836: lrx pain monthly dx~001~all other nsaids~1043676~001~1043676~001~osr~401~01~orals,sol,tab/cap re~156720~50mg~ansaid~100 0170-07

in here, need info between columns separated ~ i.e. column 1 should have '7318', column 2 should have '97836: lrx pain monthly dx'.

can help me this? can done using flat file source or need utilize script task?

sure can, need configure "column delimiter" property in "flat file connection manager editor". there predetermined choices there, can click , type separator want:

after can click "refresh" , "ok".

sql-server ssis delimiter flat-file tilde