Home Forums Data Warehousing Integration Services Splitting single comma separated line RE: Splitting single comma separated line

  • February 14, 2014 at 5:11 am

    #1689031

    abhas (2/14/2014)

    Hi All,

    My source file is coma separated file having 6 columns. But some times two lines are merging i.e. eow containas 12 columns instead of 6 and my package is failing.

    Kindly guide me how can i handle this issue?

    Thanks

    Abhas.

    Should not be your problem.

    Speak to the people responsible for producing the source file and ask them to fix up the bug which is causing the issue.