SSIS C# Script Task not reading variable or parameter

Question

I have a C# Script Task in an SSIS 2016 project, using Visual Studio 2017 SSDT version.

The Script task builds the body message of an email, Send Email Task later sends the email. Script task is able to read package variables with data from a query, everything works great, but, there is one variable that it doesn't read the actual value, rather, replaces the value with "Microsoft.SqlServer.Dts.Runtime.Variable".

I have tried with project parameters, package variables, etc., but nothing works. In the past, in other SSIS projects I was able to do this. Script Task is not generating any errors, runs fine, it just doesn't read the actual value of the variable or parameter. Weird.

What is the datatype of the variable you are having issues reading? Is it an Object? Or would it be a string with more than 8000 characters (this can cause issues)? How is it being populated? — Brad
– Brad, Commented Mar 15, 2019 at 14:59
In SSIS it is a Project param of String data type. Contents is just text, currently 119 characters. In the past I have done this with larger strings w/o any issues. — Ahpitre
– Ahpitre, Commented Mar 15, 2019 at 15:05
Ok, just confirming its not object (those need to be handled differently) and if string is super large can cause issues as well. — Brad
– Brad, Commented Mar 15, 2019 at 15:22
Found the issue, one line of code was using variablename.ToString(). Changed it to variablename.Value. This would also work (although really not needed) : variablename.Value.ToString() Works now. — Ahpitre
– Ahpitre, Commented Mar 15, 2019 at 15:45

Hadi · Accepted Answer · 2019-03-15 19:59:29Z

2

Found the issue, one line of code was using variablename.ToString(). Changed it to variablename.Value.

This would also work (although really not needed) : variablename.Value.ToString()

Works now.

edited Mar 15, 2019 at 19:59

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

answered Mar 15, 2019 at 18:36

Ahpitre

1731 gold badge2 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Yahfoufi Over a year ago

even if this is your own answer you have to mark it accepted. click on the mark on the left side of the answer.

Collectives™ on Stack Overflow

SSIS C# Script Task not reading variable or parameter

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related