Post reply

SSIS - How you delimit end of file ?

  • May 8, 2009 at 10:56 am

    #131233

    I am using SSIS to delimit my input text files. I only want to use some of the information at the top of the file: name, address etc. then i want to grab the rest of the document and dump it into a big storage field.

    What delimiter do i use for end of file ?

    Thanks

  • May 8, 2009 at 11:03 am

    #991320

    Is deactivating the delimiter the solution ?

    Thanks

  • May 8, 2009 at 11:25 am

    #991341

    So is this what you mean? Your file looks something like this:

    Field1,Field2,Field3,Field4,Field5,Field6

    1,2,3,4,5,6

    6,5,4,3,2,1

    And you want to pull it out something like this:

    FIELD1 FIELD2 FIELD3 TheREST

    1 2 3 4,5,6

    6 5 4 3,2,1

  • May 8, 2009 at 1:40 pm

    #991430

    I got it working by deactivating the delimiter but thanks anyway!

    I have a new issue with the Foreach loop function.

    I have no idea why it is failing and i get the dreaded red box.

    It loads one file fine but fails on loading multiples.

  • May 8, 2009 at 2:00 pm

    #991445

    It loads the first file in the folder, then goes to the sixth file in the folder then stops ?

    Any suggestions ?

Viewing 5 posts - 1 through 4 (of 4 total)

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