Nevyn (3/5/2014)

---

Koen Verbeeck (3/5/2014)

---

Interesting question, but I do not agree entirely with the answer.

Setting the commit size to a lower value will commit batches before the entire load is done....

I doubt it if there will ever be training kits for these exams. Especially 70-467, that exam is geared towards users with experience with the BI stack, not people who...

According to BOL (emphasis is mine):

ALL is the default.

COUNT (Transact-SQL)

John Mitchell-245523 (3/5/2014)

---

Koen Verbeeck (3/5/2014)

---

Interesting question, but I do not agree entirely with the answer.

Setting the commit size to a lower value will commit batches before the entire load is...

Interesting question, but I do not agree entirely with the answer.

Setting the commit size to a lower value will commit batches before the entire load is done. What if something...

Indeed it does, didn't even know it existed on SQL Server 😀

What is the error the source is giving?

Jeff Moden (3/4/2014)

---

Koen Verbeeck (3/4/2014)

---

I'm not sure you can read Excel with bcp (you can write to Excel with bcp though).

You can use FROM OPENROWSET to read an excel file,...

At 1000 pages, SSRS just seems the wrong tool for the job.

A clever .NET program will probably be more efficient.

Why don't you just use the precedence constraint with the OnFailure option (the red arrows)?

ms-techie (2/23/2014)

---

Our SSIS packages are automated to run in production via JOBS which use the DTExec.exe line to invoke the individual packages

We have a total of 25 jobs like this....

I'm not sure you can read Excel with bcp (you can write to Excel with bcp though).

You can use FROM OPENROWSET to read an excel file, or just use SSIS...

It depends on the OLE DB provider I think.

It's possible the Microsoft OLE DB provider...

I think the difference is due to the leap year bug in Excel:

http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

Select (1/(SUM(Rows)/1846415)) * (CURRENT_TIMESTAMP - '2014-03-04 10:51:00.380')

This won't work as CURRENT_TIMESTAMP is Oracle and SUM(Rows) is not possible...

Your statement won't work 100%, because if only one is missing, nothing is inserted at all.

Try this:

WITH CTE_InsertValues AS

(

SELECT UserID = 200, GroupID = 100

...