Post reply

SSIS - Variable Input File Length - How to Parse a text document based on a text string ?

  • May 13, 2009 at 8:12 am

    #131340

    I have a number of variable length input files and need to set up my parsing based on a text string. Within SSIS, i have only been able to find parsing options based on comma, tab, semi colon etc...

    How would one do this ?

    Thanks

  • May 13, 2009 at 8:25 am

    #993763

    a BCP task might be a better option if the file structure is straight forward.

    Alternatively use a script or derived column task to split 1 column into several

  • May 14, 2009 at 7:18 am

    #994486

    Thanks

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

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