Help with JavaScript Component

19 views
Skip to first unread message

John Nickell

unread,
Apr 25, 2024, 4:42:07 PM4/25/24
to COZYROC
I am attempting to use the pre-built JavaScript Transformation for "Split Column Transformation" and cannot get it to run without an error about a column I'm not even using. 

I'm doing the following:
  • Once I've added the component to the Dataflow, I then connect it to the previous step (Rest Destination).  
  • Double Click on the component to choose what script I want to use. 
    • I've selected the Split Column Transformation and click Ok
  • In the next window I supply the column (OrderRecords) from the previous step and the delimiter (", ")
  • I then click okay.
  • I believe I next have to go to the Advanced Editor to select the desired Input Column (OrderRecords) and then create a Output Column (Orders). I gave the column a name and set the datatype to DT_WSTR 
  • Then try running the debug for the dataflow. I get the following error:
    • [JavaScript Component [524]] Error: Jurassic.JavaScriptException: Error: The column with name "Id" does not exist.

I've looked at this page  Script Split Column Transformation | COZYROC but it's not giving me any more pointers and after following the other JavaScript Component pages (https://www.cozyroc.com/ssis/javascript-component) I updated the Advanced Editor windows. It was only after going to the Advanced Editor that I got any column names to show up in the "Properties > Metadata" window even though the earlier doc doesn't seem to mention this requirement at all.
 
There is an "Id" column in the output of the previous step but I'm not trying to use it in the JavaScript component and it's not checked in the "Advanced Editor" > "Input Columns".  It is the first one listed though in this window. 

Am I missing something?  If so what?  Thanks for any pointers

John Nickell

unread,
Apr 25, 2024, 4:49:51 PM4/25/24
to COZYROC
If I add "Id" as an Input & Output Column in Advanced Editor the error shifts to the next column from the previous step's output.  I don't need every column. I really only need a single column from the output of the previous step.
Reply all
Reply to author
Forward
0 new messages