I have DTS in SQL SERVER 2000 that I have rewritten it as SSIS in sql server 2008,In this SSIS I am trying to transfer data from log file to table.I have used the same setting that I had used in DTS.But the Column delimiter(Which is Comma) does not work properly, and does not detect the columns correctly.
I would appricate if someone help me on that.