Home Forums SQL Server 2005 SQL Server 2005 Integration Services export fixed-length flat file RE: export fixed-length flat file

  • May 22, 2008 at 11:24 am

    #819276

    Like so:

    SELECT

    CONVERT(CHAR(10), Title)

    +CONVERT(CHAR(75), FirstName)

    +CONVERT(CHAR(75), LastName)

    +CONVERT(CHAR(100), EmailAddress)

    FROM

    AdventureWorks.Person.Contact

    Cheers,

    Ben Sullins
    bensullins.com
    Beer is my primary key...