Awesome video. I enjoyed watching this video and recommend others to watch. Narration and examples are very good. Thanks for educating the community and your volunteer-ship is appreciated. Please keep producing some more videos. Thanks a bunch
Thanks for the great video. I'm using SQL server 2013, I have followed the same instructions & used your script. Struggled with compilation errors . // This is where I had issues. Row.intSeries = s; Row.intPosition = p; It worked when I converted local variables s & p to the following Row.intSeries = Convert.ToUInt32(s); Row.intPosition = Convert.ToUInt32(p);
Great Video. When I exit the Validate Data Script the red x wouldn't go away and the error reads "Binary Code for script not found". I copied the Wise Owl blog 395 "Files needed for RUclips tutorial on SSIS script components", I found an error for the validate script for C#. int s = 0 and int p should read uint s = 0, uint p = 0. Also, s = Convert.ToInt32(Row.SeriesNumber) should read s = Convert.ToUInt32(Row.SeriesNumber) and s = Convert.ToInt32(Row.SeriesNumber) should be p = Convert.ToUInt32(Row.SeriesNumber) ... No offense I just thought I mention it in case someone else ran into that issue.
Please help me with this error (Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.).
Thanks for great video. I have a question though. Why are the output columns intPosition and intSeries unsigned integers and not just regular signed integers?
I'm a bit confused. You seem to modify the output columns Problem and IfGood via the Input0Buffer Row. I haven't seen this (modifying output via input rows) done or documented anywhere else. When I try the same thing in my scripts I get an error. How are you able to do this?
I think he meant to define all the file inputs as strings, and the script to return the int version of Series & Position. He accidentally defined the input as integer, and then did another ToInt conversion in the script. What you ought to do is to define every column as string in the input file, because "1" can always be interpreted as a string, but "abc" can't be interpreted as an integer.....
Love it when you put simple mistakes in the code for me to find & fix. It certainly enhances the learning!
Awesome video. I enjoyed watching this video and recommend others to watch. Narration and examples are very good. Thanks for educating the community and your volunteer-ship is appreciated. Please keep producing some more videos. Thanks a bunch
Thank you for the excellent step-by-step explanation
Thanks for sharing this video. As usual very informative and very entertaining.
Thanks for the great video. I'm using SQL server 2013, I have followed the same instructions & used your script. Struggled with compilation errors .
// This is where I had issues.
Row.intSeries = s; Row.intPosition = p;
It worked when I converted local variables s & p to the following
Row.intSeries = Convert.ToUInt32(s);
Row.intPosition = Convert.ToUInt32(p);
thanks for your comment!
it works for me too.
Great Video. When I exit the Validate Data Script the red x wouldn't go away and the error reads "Binary Code for script not found". I copied the Wise Owl blog 395 "Files needed for RUclips tutorial on SSIS script components", I found an error for the validate script for C#. int s = 0 and int p should read uint s = 0, uint p = 0. Also, s = Convert.ToInt32(Row.SeriesNumber) should read s = Convert.ToUInt32(Row.SeriesNumber) and s = Convert.ToInt32(Row.SeriesNumber) should be p = Convert.ToUInt32(Row.SeriesNumber) ... No offense I just thought I mention it in case someone else ran into that issue.
Thanks, I DID run into this
Amazing! Thanks!
Please help me with this error (Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.).
When you create a flat file connection in data flow what is the difference between a flat file connection in package level vs project level? Thanks.
was wondering if there are plans for a SSIS slowly changing dimension tutorial?
Shouldn't tblBadContestant have a schema with all strings so that you would capture the original data?
Thanks for great video. I have a question though. Why are the output columns intPosition and intSeries unsigned integers and not just regular signed integers?
theoldhopbarn I think the answer to that is that they should be signed integers!
Could someone finish in the -3rd place in the -15th series?
I'm a bit confused. You seem to modify the output columns Problem and IfGood via the Input0Buffer Row. I haven't seen this (modifying output via input rows) done or documented anywhere else. When I try the same thing in my scripts I get an error. How are you able to do this?
Input0Buffer is poorly named, It includes input and additional output columns. Did you set the input columns to read / write ?
I think he meant to define all the file inputs as strings, and the script to return the int version of Series & Position. He accidentally defined the input as integer, and then did another ToInt conversion in the script. What you ought to do is to define every column as string in the input file, because "1" can always be interpreted as a string, but "abc" can't be interpreted as an integer.....
Please help
I can help you