danielfountain (12/5/2012)

---

Koen Verbeeck (12/5/2012)

---

Why would you want to install the x86 ACE OLE DB provider on your server? As Phil said, there's no difference between an Excel file created...

There are some flaws in this article:

* Run64BitRuntime is a design-time debugging property, which has nothing to do with packages running on a server.

* Why would you want to install...

Nice easy question, thanks.

Great question Ron, thanks!

Great but difficult question. Thanks Tom.

Great, glad you got it solved.

Stefan Krzywicki (11/30/2012)

---

Koen Verbeeck (11/30/2012)

---

I once had a fact table that could have more than 2 billion rows, but still less than a bigint, so I started with a negative...

I once had a fact table that could have more than 2 billion rows, but still less than a bigint, so I started with a negative seed so I could...

So you would rather blindly take code off the internet, copy paste it into your application and support/maintain it in production? You know you're responsible for the code you deliver,...

Read everything in with an Excel source.

After that, put a script component as a transformation.

Send all the rows to a certain output, but check first if the value of the...

Mighty (11/30/2012)

---

This would have been a basic question, if it would have had two create table statements to accompany it. Now it was unclear, and left much room for assumptions,...

subramani.rudrappa 78855 (11/30/2012)

---

Hi,

There is also another way to change the way the Excel drivers 'determine' the datatype of a column and that is to use the IMEX=1 switch on the...

Yes. But changing it is also normal.

Just because the default prevents something,...

Yes there is. You can set the TypeGuessRows registry property to change the amount of sample rows.

(the default is 8 by the way, not 10).

More information:

What’s the deal with Excel...

Got it wrong because you can update or delete rows in the primary tables if you specify ON CASCADE options.

Next time do more homework please.