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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.