Hi All,
I have a SSIS package where I import a load of data. I then generate an email to inform the users what data has been imported etc.
To do this I use a sql script component to build the contents of the email into a user defined variable and then use that variable as the message source. (just builds a list of names etc)
The SSIS variable is of type string and looking around that shouldn't have any size limitations in this context.
I my sql that I use to build the text I am using a varchar(8000) variable to complie all the text.
Running this SQL code in management stuido runs fine with no truncation.
when I run this process in SSIS it builds and sends the email but seems to truncate the email body text to around 3300 characters but I have no idea where or why it is doing this.
Any advice would be greatly apperciated!
Thanks
Dave