3

I need some assistance with the syntax of a system URL for a SSIS Derived Column. I have triple checked the package fields CO_ID and ProcessNo, so I must be missing something in the URL syntax.

"<a href=\"" + "https://pub.mickle.com /orders/Subsystem/Utils/RequestDoo.asp?ID=" + ORDER No class="nounderline" title="">" + "Order No" + CO_ID + ProcessNo + "</a>"

Any assistance to guide me into the light is appreciated

Hadi
  • 36,233
  • 13
  • 65
  • 124
David F
  • 265
  • 2
  • 14
  • Please don't ask a question without explaining the issue. Do you get an error? Does it have an incorrect result? If so, what is the correct result? – Nick.Mc Jan 09 '18 at 23:54
  • @DavidF did you tried my suggestion? Always give a feedback to get more help. – Hadi Jan 12 '18 at 10:18

1 Answers1

0

There are many issues in this expression:

  • Additional space after the .com domain : https://pub.mickle.com /orders
  • Double quotes escapes missing.
  • Missing Bracket around Columns names (because columns names like ORDER No contains spaces)

I think you are looking for the following expression:

"<a href=\"https://pub.mickle.com/orders/Subsystem/Utils/RequestDoo.asp?ID=" + [ORDER No] + " class=\"nounderline\" title=\"\"> Order No" + [CO_ID] + [ProcessNo] + "</a>"

Also, if [ORDER No], [CO_ID] or [ProcessNo] are numeric columns then you should use CAST operation:

"<a href=\"https://pub.mickle.com/orders/Subsystem/Utils/RequestDoo.asp?ID=" + (DT_WSTR,50)[ORDER No] + " class=\"nounderline\" title=\"\"> Order No" + (DT_WSTR,50)[CO_ID] + (DT_WSTR,50)[ProcessNo] + "</a>"
Hadi
  • 36,233
  • 13
  • 65
  • 124