SSIS and the TOKEN function

  • Richard Warr

    SSCertifiable

    Points: 6955

    Comments posted to this topic are about the item SSIS and the TOKEN function

    _____________________________________________________________________
    MCSA SQL Server 2012

  • rhythmk

    SSCertifiable

    Points: 7162

    Thanks for quetion Richard.It was nice to learn new thing.Have never used it.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Richard Warr

    SSCertifiable

    Points: 6955

    Thanks. It was a function that I'd never heard of either but came across it whilst looking up something else a couple of weeks back. It looks as though it can be really useful so I hope others find it interesting.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • pmadhavapeddi22

    SSCertifiable

    Points: 5306

    Thanks for the question Richard. Learnt something new

  • Ed Wagner

    SSC Guru

    Points: 286957

    I had never heard of it either, so I learned something new.

  • Hany Helmy

    SSChampion

    Points: 13321

    Ed Wagner (5/28/2014)


    I had never heard of it either, so I learned something new.

    Me neither 😎

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    Thank you for the post, RW, this was very very unique and interesting.

    (actually I had difficulty in looking where this word "token" comes under, first: I searched in the index: load of items appeared, I failed. Then later I searched in the net and came to know it is listed under SSIS Expressions, wow that's something new, then went back and searched looked under Integration Services (SSIS) Expressions, under function, bingo... there it was... ah and then it was piece a cake.. :D)

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • This was removed by the editor as SPAM

  • Dana Medley

    SSCertifiable

    Points: 6764

    Thanks for the question Richard. It took some digging to figure this one out. I've never used this function before so I learned something new today.



    Everything is awesome!

  • RLilj33

    SSCrazy

    Points: 2146

    Ever focus on something too hard? I looked at this question and did some research. Determined the correct answer, then proceeded to select the wrong one... :blush:

    Thanks for the question!

  • josborne 48714

    SSC Enthusiast

    Points: 157

    The answer to this question is incorrect; technically speaking.

    The double quote characters are going to throw a syntax error when this is run. The statement should be using single quotes.

  • josborne 48714

    SSC Enthusiast

    Points: 157

    Unless of course the rules for SSIS are different than TSQL...I haven't used it all that much.

  • Thomas Abraham

    SSChampion

    Points: 10761

    Nice question. Looks like a function I would find useful, if I ever get to work on SQL Server 2012.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • Richard Warr

    SSCertifiable

    Points: 6955

    josborne 48714 (5/28/2014)


    Unless of course the rules for SSIS are different than TSQL...I haven't used it all that much.

    Yes, it's double quotes for SSIS functions and single for T-SQL.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Stephanie J Brown

    Hall of Fame

    Points: 3866

    What I found most interesting is that you can list multiple delimiters. Could come in handy for parsing out data such as when name and address are co-mingled in a single field. (Yes, I know WE don't do that, but incoming data can be soooooo dirty sometimes... :hehe: )


    Here there be dragons...,

    Steph Brown

Viewing 15 posts - 1 through 15 (of 19 total)

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