Did you check the system tables? If nothing pops up you can try to run a trace with profiler against the database when the package is running, to see if...

What exactly do you mean with a file?

A database table, or an actual file, such as a flat file (.csv)?

I thought BO was for reporting 🙂

Anyway, you probably won't find a comparison chart for Kettle and SSIS because Ketlle is a relative unknown player.

I've used Kettle a few years...

Indeed. For more information:

Features Supported by the Editions of SQL Server 2008 R2

Because you can rollback...

Jeff Moden (2/5/2012)

---

quynh012012 (1/6/2012)

---

quynh012012 (1/3/2012)

---

Hi,

I do not agreed with you. Any way, your points of view make me thinking about some thing for my project.

Pls try to keep posting. Tks...

I usually get the answer: "we've always worked that way. Code around it..." :rolleyes:

Jeff Moden (2/5/2012)

---

As a sidebar, I generally don't import directly from Excel spreadsheets because you can't tell when someone might have it open. I usually tell people to do...

Easy one, thanks to Paul Randals DBA Myth A Day. 🙂

Samit Shah (2/3/2012)

---

Thanks Koen and Bru.

I have already created incremental load for 1 table using merge join. I am thinking to make it generic, so that I dont have to...

Charmer (2/3/2012)

---

Koen Verbeeck (2/3/2012)

---

Charmer (2/3/2012)

---

Koen Verbeeck (2/3/2012)

---

You can't use the object variable in a conditional split, as the component expects scalar values.

In the For Each Loop, you need to map...

MysteryJimbo (2/4/2012)

---

I should point out that (unless someone corrects me) there are still no 64-bit excel drivers for SSIS. You will need to execute the package using the 32-bit...

I was referring to the smiley that...

But you have to select SQL Server 2008R2 from the list instead of Denali in the set-up...

Try the OLE DB Destination using the Microsoft OLE DB for ODBC provider.