SSIS convert object variable to string

Question

I would like to store a single row result set to a variable. To able to do this I have to set my variable TxtNotes to Object. The issue I'm having is using this TxtNotes variable to use with nother string variable. Something like: EmailBody = "We have notes: " + "\n" + @[User::TxtNotes] I have tried this article: ssis 2008, convert object to string on Expression Builder I keep getting this error: Error: 0xC0019001 at Script Task: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property. Help needed. Thanks.

Ardalan Shahgholi · Accepted Answer · 2020-06-22 18:28:40Z

1

Just found a solution:

Using CAST(txtnotes AS varchar(8000)) AS TxtNotes

in Execute SQL Task.

edited Jun 22, 2020 at 18:28

Ardalan Shahgholi

12.7k25 gold badges116 silver badges155 bronze badges

answered May 9, 2013 at 21:06

tkvo

1715 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

SSIS convert object variable to string

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related