Problem in transfering data from log file to table

  • 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.

  • Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic690756-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply