Home Forums Data Warehousing Integration Services Extracting VarBinary(MAX) column to Flat File - Facing Issue. RE: Extracting VarBinary(MAX) column to Flat File - Facing Issue.

  • July 24, 2014 at 10:57 am

    #1732154

    windows_mss (7/24/2014)

    Hi Evil,

    Thanks for your reply, when i prepend 0x in script it's working. But when i tried the same in SSIS using derived column I'm getting exception(i have attached the screenshot as attachment)

    Expressions don't use the same quotation components.

    You want "0x" + @Column

    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
    Twitter: @AnyWayDBA