You can't configure that in the job itself, so I would just create another job that runs in the morning to check if the other job succeeded or not.

They will all be negative, except...

bleroy (4/14/2012)

---

I would tihnk that since you are moving this to a data warehouse, you would want to have the calculations performed during the ETL process and only store the...

asranantha (4/16/2012)

---

Hi friends,

i have small doubts in ssrs plz tell me the answers

1)how to call stored procedure in ssrs reports ?plz tell me the process

2)how to call ...

In the dimension browser, you can only browse the individual attributes of your dimension. If you want to see them side by side, you can create an attribute that combines...

You'll have to install sp4 first before you do the upgrade to 2012.

You can build SSAS on top of SQL Server views. You need however to create facts and dimensions in SSAS.

But Excel can pivot very nicely on top of a SSAS...

Got it wrong, because I didn't know log file and log backup apparently are the same thing.

Anyhow, it made me think, so a part of the question was succesfull.

When I look...

How many rows are there already in the destination table? Maybe you should consider partition switching.

The SSIS package design looks OK, there are no indexes, constraints, excessive logging, so this leaves the disks (storage), the network and maybe the I/O bus?

Maybe there are some other...

You can copy packages from server to server with DTUTIL.

GSquared (4/13/2012)

---

I asked which features, and he fumbled around and made some tentative comments about CLR (this was last year, CLR is old news these days), and about...

I don't see the issue.

How does the order of columns matter? It's just a temp table.

What do you mean with column index?

You can either specify the columns names, or just add two clauses: ALTER TABLE #TempTest DROP COLUMN ID and ALTER TABLE #TempTest ADD ID...