SSIS and the TOKEN function

Question

SSIS and the TOKEN function

Richard Warr

SSCertifiable

Points: 6963
More actions
May 27, 2014 at 10:29 pm

#286015

Comments posted to this topic are about the item SSIS and the TOKEN function
May 28, 2014 at 7:48 am

This was removed by the editor as SPAM

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

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

rhythmk SSCertifiable Points: 7271 More actions · Answer 1

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: 6963 More actions · Answer 2

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.

pmadhavapeddi22 SSCertifiable Points: 5306 More actions · Answer 3

Thanks for the question Richard. Learnt something new

Ed Wagner SSC Guru Points: 287024 More actions · Answer 4

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

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Hany Helmy SSChampion Points: 13921 More actions · Answer 5

Ed Wagner (5/28/2014)
I had never heard of it either, so I learned something new.

Me neither 😎

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 6

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.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 7

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: 2153 More actions · Answer 8

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 Veteran Points: 257 More actions · Answer 9

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 Veteran Points: 257 More actions · Answer 10

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

Thomas Abraham SSChampion Points: 10761 More actions · Answer 11

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: 6963 More actions · Answer 12

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.

Stephanie J Brown Hall of Fame Points: 3876 More actions · Answer 13

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