Vimal Lohani (9/11/2014)

---

TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log.

this means if...

TomThomson (9/11/2014)

---

+1000000

It's amazing, when even the reference...

If you are using Excel 2007 or higher, you need to install the 64-bit ACE OLE DB provider.

What data type did you pick in the source component in the data flow?

DT_TEXT?

If the source is unicode, it should be DT_NTEXT.

Please don't say truncate table data isn't logged unless you understand the concepts involved.

😉

The Myth that DROP and TRUNCATE TABLE are Non-Logged

Are both parameters set to visible?

Tables don't have an order.

The identity might help if you put a clustered index on it and if all the queries on the table use ORDER BY ID.

Interesting, albeit megalomaniacal question 😀

KoldCoffee (9/9/2014)

---

Yeah, I'm learning SSRS. My boss knows that.

I'm asking for help with one small part of a report and not for advise on why I am bringing...

Sean Lange (9/9/2014)

---

Koen Verbeeck (9/9/2014)

---

Steve Jones - SSC Editor (9/9/2014)

---

BTW, it's not that kids aren't important, but it's a balance. I don't look at it as "if I died tomorrow"....

Steve Jones - SSC Editor (9/9/2014)

---

BTW, it's not that kids aren't important, but it's a balance. I don't look at it as "if I died tomorrow". If I did that,...

If you have SQL Server 2012 you can start an SSIS package from a stored procedure 😉

Integration Services?

Well, I hope Steve corrects the issue and awards points back.

I thought I lost my sanity there for a moment 🙂

The error is quite clear.