Home Forums SQL Server 2005 SQL Server 2005 Integration Services Problem using expression in SSIS RE: Problem using expression in SSIS

  • August 2, 2012 at 8:08 am

    #1520854

    herladygeekedness (8/2/2012)

    Devesh_Srivastava (8/1/2012)

    substring ("Archive_Full_20120731200002",1, (FINDSTRING( "Archive_Full_20120731200002","Full_", 1)-2))

    Then how come the above expression is working where the exact string is used instead of a variable and still negative value is accepted!!! Does it make sense ?

    Good question. I only know that when attempting to put in a negative value for length in a much simpler expression, it errored on negative value of length parameter.

    The result of

    FINDSTRING( "Archive_Full_20120731200002","Full_", 1) -2

    is 7. That's not a negative value where I come from 🙂

    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.