Got it! The basic problem was the size of the output string.

The information here explained that I needed to use an Object variable type since I overflowed the String.

Note...

Sadly I have next to no C# experience nor do the folks around me. So I'm hacking through this.

I'm not getting a max value. I'm executing a stored...

Orlando - I can send the message just fine. The step that's tripping me up is getting the output of a stored procedure into a string variable that can...

Policies. We can connect to the SMTP server in SSIS but can't use db_sendmail.

I know I'm just missing some basic C# stuff here so I'll keep digging around on...

Move should let you do what you want including renaming the file.

Define 'true'.

The production code - the code the DBA pulls from the server - is just that. The code currently in production. It ~should~ match one of the...

The original plan was to use SSRS but that's not an option here right now. So throw that one out the window.

Second plan was to make Excel files and...

I'm using a stored procedure to generate the HTML necessary for the email. That outputs to a string variable. However the SSIS string variable doesn't recognize varchar(max) as...

What error(s) are you getting? Right now I don't see anything wrong with your syntax.

Is the data flow expecting that data type to be a date and you're pushing...

I'm with the folks who suggest enforcing this through code review and developer involvement. And yes they WILL disable the trigger if it's annoying them.

One possible thing to do...

The ONLY business reason I can think of for this situation is a legal requirement that there be no gaps in the numbering. There's a vague memory of a...

I give up.

It seems like SSIS is OK with dynamic Excel files when they're a data source but when it comes to a destination it stomps its little foot and...

As I said - SSIS is very picky when it comes to data types. You've changed one and now the metadata is out of sync.

Your best bet is to...

Yeah. Target. I was kind of watching a few processes when I wrote that. Thanks for the catch.

Get...

SSIS is .. picky about data types.

The solution to this one is either to cast it before it ever hits the data source or do add a Data Conversion transformation...