Search code examples
htmlssisderived-column

URL in SSIS Derived Column

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.

Solution

  • 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>"