I may be off in left field, but out of curiousity, what OLE-DB Provider are you using for your connection? Are you sure it is up-to date?

Your syntax appears fine. Double check the database that your running it on (or add DATABASENAME.dbo.TABLENAME), the name of the fields, and the name of the table.

Your Welcome! Glad it helped.

Just and FYI, you can send mail from SSIS.

1) Use an Execute SQL Task to pull the variabels

2) Create a Send Mail Task; set Expressions to map the variables to...

Have you tried adding the entire report header into the table header? You can either do this (I have used this for reports where information from a group needs to...

I think GilaMonster is right in that this additional table seems unnecessary. Why not create a view with the summarized fields (using a pivot)?

Either create a Script Task to load all file names of the specific type into a variable (an object variable) and do a "ForEach Loop" on that variable, or create...

I think Yuri Nogin has it right; to create an easily deployable Maintenance plan create an SSIS package. The one amendment I would have is that I would leave the...

Ah. No, I meant "Hour(..)", I just may have been (okay, so I WAS... :P) mistaken by the edition. I currenty use 2005 on almost all my servers, and "HOUR(DATEFIELDNAME)"...

Again...

[font="Courier New"]SELECT store_code

, convert (char(10),getdate(),103) as Business_Date

, SUM(CASE Hour(transaction_date_time) WHEN 0 THEN Sales ELSE 0 END) AS SalesHr1

, SUM(CASE Hour(transaction_date_time) WHEN 0 THEN Tax ELSE 0 END) AS TaxHr1

, SUM(CASE...

I have already attempted this as a solution, but the job will not necessarily "fail" if the report fails to generate. I am working on a solution, but any suggestions...

I am not commenting on a solution, but I was going to post a request for this same issue. The only thing I can think is to set up an...

Have you tried clearing your cache for the Query Optimizer? It could be that it is using a bad plan for the "SELECT *". You may need to clear the...

Ah, I think you are right... I shoudl have read the location of the post.

A long but working query should work for you:

SELECT Store, Till

, SUM(CASE [Hour] WHEN 1 THEN...

We have three levels of replication that we are currently using in DB Moto. Basically, one type of replication is a "Refresh" where it is a truncate and a full...