SSIS Design Pattern - Staging Fixed Width Flat Files

  • Take Flat File source with Fixed width Format and then in advance tab divide your data by giving length of each column next in column tab set your width exactly.

    But this will work only when your are aware of each column length.

  • I'd be interested in seeing the same type flow with a delimited file.

Viewing 2 posts - 16 through 16 (of 16 total)

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