0

I am trying to add a URL to a SSIS derived column expression. However, it errors. The column will be

I understand that it is possible, but I cannot get it to work correctly. Below is the last expression I tried. I placed it in a snippet because not all tags were presenting in my question. Additionally, the URL is bogus.

"<a href=\""+"https://team.track.team.com/track/track.dll?View&I=14782&T=1000"+\"">"+"Click"+"</a>"

Any assistance is greatly appreciated.

David F
  • 265
  • 2
  • 14
  • BTW... I added a Data Conversion before (DT_WSTR, «length»). – David F Oct 10 '17 at 20:40
  • Additionally, I tried the simplistic route starting the expression with ==. – David F Oct 10 '17 at 20:41
  • I'm not familiar with SSIS, but it looks like you have a `\"` outside of a quotes (after the URL string). Is that intentional? Specifically it looks like `+\"">"` should probably read `+"\">"` – Nathan Hinchey Oct 10 '17 at 22:56
  • 1
    Ever had one of those bang your head against the wall moments because you couldn't see the forest for the trees. Your correction worked. Thank you! – David F Oct 11 '17 at 15:24

2 Answers2

1

Not sure what you're trying but if your aim is to anchor the URL with 'click', then this seems to be working :

"<a href=https://team.track.team.com/track/track.dll?View&I=14782&T=1000>Click</a>"
Prabhat G
  • 2,974
  • 1
  • 22
  • 31
0

You have a typo

You have a \" outside of a quotes (after the URL string).

Specifically it looks like +\"">" should read +"\">"

Nathan Hinchey
  • 1,191
  • 9
  • 30