I current want to add a new column that allow me to add row number within a data flow task in SSIS (row number increments with each new row).
So far I have been using the following code from this guide:
I currently am using Visual Studio 2015.
<ul>
<li><a href="https://hansmichielscom.wordpress.c...a-rownumber-to-a-data-flow-task-in-ssis-2012/" rel="nofollow noreferrer">HOW TO ADD A ROWNUMBER TO A DATA FLOW TASK IN SSIS 2012</a></li>
</ul>
However, once I run the script I am getting the current error. Seems like it's saying there's a bug in the script, although I can't find this. Also note that I am very new to writing scripts, so I am having some difficulties with this.
<blockquote>
Error at Grab landing data and populate staging [Script Component [88]]: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully.
Error at Grab landing data and populate staging [Script Component [88]]: The script component includes no code. Edit the component to include code.
Error at Grab landing data and populate staging [SSIS.Pipeline]: "Script Component" failed validation and returned validation status "VS_ISBROKEN".
Error at Grab landing data and populate staging [SSIS.Pipeline]: One or more component failed validation.
Error at Grab landing data and populate staging: There were errors during task validation.
</blockquote>
Any suggestions will help, thanks!
So far I have been using the following code from this guide:
I currently am using Visual Studio 2015.
<ul>
<li><a href="https://hansmichielscom.wordpress.c...a-rownumber-to-a-data-flow-task-in-ssis-2012/" rel="nofollow noreferrer">HOW TO ADD A ROWNUMBER TO A DATA FLOW TASK IN SSIS 2012</a></li>
</ul>
However, once I run the script I am getting the current error. Seems like it's saying there's a bug in the script, although I can't find this. Also note that I am very new to writing scripts, so I am having some difficulties with this.
<blockquote>
Error at Grab landing data and populate staging [Script Component [88]]: The binary code for the script is not found. Please open the script in the designer by clicking Edit Script button and make sure it builds successfully.
Error at Grab landing data and populate staging [Script Component [88]]: The script component includes no code. Edit the component to include code.
Error at Grab landing data and populate staging [SSIS.Pipeline]: "Script Component" failed validation and returned validation status "VS_ISBROKEN".
Error at Grab landing data and populate staging [SSIS.Pipeline]: One or more component failed validation.
Error at Grab landing data and populate staging: There were errors during task validation.
</blockquote>
Any suggestions will help, thanks!