Post reply

Flat file import problems

  • September 28, 2010 at 2:04 am

    #157225

    I am importing data from flat files, in some cases (files) only every second row gets imported, I am sure it has something to do with Linefeed, any ideas why

  • September 28, 2010 at 7:16 am

    #1228315

    Please give us more information on the connection manager which points to your flat files.

    Also, does the flat file have any header rows or titles?

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • September 28, 2010 at 9:28 am

    #1228472

    Without having seen the connection manager details, I'm guessing that there might be a problem with the delimiter of the end of row.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

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

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