Post reply

How to convert Varbinary(10) to a SSIS variable

  • March 11, 2013 at 11:05 am

    #1595675

    After googling substantially before hand I stumbled across a blog linked to a codeplex sample. Trawling thorough that I got to

    EXECUTE SQL TAsk contains:

    declare

    @startLSN binary(10),

    @startLSN_str nvarchar(42)

    select @startLSN = sys.fn_cdc_get_max_lsn()

    select @startLSN_str = upper(sys.fn_varbintohexstr(@startLSN))

    select @startLSN_str as PkgLSNEnd

    This then returns data to a string that I can put in a package String variable.

    They dont make this easy 🙂

  • April 25, 2018 at 10:05 am

    #1988223

    Awesome, just what I was looking for. 🙂

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

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