Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL Writing variable length records to a flat file destination in SSIS RE: Writing variable length records to a flat file destination in SSIS

  • February 28, 2018 at 11:34 am

    #1981519

    Robert Frasca - Wednesday, February 28, 2018 10:05 AM

    Phil Parkin - Wednesday, February 28, 2018 9:22 AM

    Nice and simple.
    Just wondering ... did you choose SUBSTRING() rather than LEFT() for any particular reason?

    I was thinking about strings and SUBSTRING was the first to come to mind. Is LEFT more efficient?

    I doubt that there is any difference in terms of performance (though I have not checked that).
    I mentioned it because
    LEFT(TextData,132)
    is equivalent to
    SUBSTRING(TextData,1,132)
    and requires seven fewer characters and one fewer function argument, making it somewhat easier on the eye (in my opinion).

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.