Create Header and detail in SSIS

  • Hello guys ,

    There is any other way to create Header and headers detail in one file ?

    Except This:

    [http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2007/09/25/multi-record-formated-flat-file-with-ssis.aspx]

  • What's wrong with this solution?

    SSIS before SQL Server 2012 isn't really flexible with flat files, so every line must have the same number of columns.

    You could always do it with a script task.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • 3935 (6/28/2012)


    Hello guys ,

    There is any other way to create Header and headers detail in one file ?

    Except This:

    [http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2007/09/25/multi-record-formated-flat-file-with-ssis.aspx]

    Do you want dynamic headers/footers, or just some static text?


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

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