In the report manager, go to the properties tab for the report and add your description there.

How many basic SQL statements will you have? Perhaps you could use an expression based precedence constraint to channel the program flow to the correct Execute SQL Task for...

Catch

First take a look at Andy Leonard's blog on dynamic SQL in variables

http://sqlblog.com/blogs/andy_leonard/archive/2007/07/22/ssis-design-pattern-dynamic-sql.aspx

In his blog he demonstrates the creation of the dynamic SQL in a variable and then uses a...

I agree that you should pay attention to leading and trailing spaces, in particular trim all of your text type columns. Where SQL Server will usually ignore those spaces,...

If you are actually using the No Match Output of the Lookup transform:

All of the columns in the input are generally available in the output regardless of match or no...

I am assuming you are using the Execute SQL Task. You can map variables to the ? in the order they appear on the Parameter Mapping tab.

I...

I am not sure of the quantity represented by a lack, but I believe it is a pretty large number. You also say "Dump report." Is this a...

Monster

Strestration: when your daily frustrations begin to turn into long term stress. 😀

My sniglet for the day. Does anyone remember...

exhausted

Begin

You should work with your mail or Exchange admin

Generally I recommend using stored procedures as a rule for reports.

Create your SP to pull your data and save it to your table, then at the end of the SP...

I was going to say this as well, your report host may not have relay permissions outside the...