Please stop posting the same thing in multiple forums!

Maybe this link is better.

http://lmgtfy.com/?q=how+to+schedule+ssrs+report+for+emailing

As far as the number of records showing up in the messages tabs is concerned, that's the way it should be.

Agree!!!

Sounds like what you're asking is beyond what this forum was intended for.

I think you need to find a good book on SSAS and start reading.

g.britton (11/13/2014)

---

The temp table in the dynamic sql is created in a different context and not available to the calling context. e.g.

DECLARE @sql nvarchar(4000) = N'create table #foo(a int)';

EXEC sp_executesql...

You might want to look into synchronization, instead of replication.

How to: Execute Database Synchronization (SQL Server)

http://msdn.microsoft.com/en-us/library/dd918848%28v=sql.110%29.aspx

Here's a few links that might be helpful:

Integration Services (SSIS) Expressions

http://msdn.microsoft.com/en-us/library/ms137547%28v=sql.110%29.aspx

SSIS Expression Cheat Sheet

http://pragmaticworks.com/Training/Resources/Cheat-Sheets/SSIS-Expression-Cheat-Sheet

I'd like to know where so many people got the idea that the database should be set to Simple Recovery Mode first.

Easiest option is to add a FileSystemTask for each file type you need to process.

I don't see a need for an Order History table. The Orders table can be...

If you want to record what the price was at the time of the order, then I would keep the price in both table. This is normal (no pun...

Same here. Thanks.

The rephrase the above question, what do you get when you run the query below?

SELECT *...

Is the suggested index based on more than one column? if so, you might have the columns in the wrong order. The suggested index does not necessarily have the...