Read this article, it has the solution to your problem:

What’s the deal with Excel & SSIS?[/url]

(tip: IMEX and TypeGuessRows)

Had to do this once, so easy one for me 😀

Thanks Steve for the question.

Did you not see the link I posted?

The problem is probably that you're not doing a bulk insert into Oracle (while you are doing a bulk insert into SQL Server, hence the performance difference).

You can try the...

Jeff Moden (2/3/2014)

---

Koen Verbeeck (2/3/2014)

---

Jeff Moden (2/2/2014)

---

Koen Verbeeck (2/2/2014)

---

asranantha (2/2/2014)

---

Hi friends, in my project having 10 packages with shared connection used.here i need deploy only single ssis package please provide...

Right click the annotation and choose "Set Text Annotation Font" from the context menu.

Jeff Moden (2/2/2014)

---

Koen Verbeeck (2/2/2014)

---

asranantha (2/2/2014)

---

Hi friends, in my project having 10 packages with shared connection used.here i need deploy only single ssis package please provide how to solve this...

asranantha (2/2/2014)

---

Hi friends, in my project having 10 packages with shared connection used.here i need deploy only single ssis package please provide how to solve this issuse ,any body provide...

Typically you have one fact table per business process.

I wouldn't store aggregated facts in the fact table (next to the low grain transactional facts).

If you want to store aggregated facts,...

Interesting question, thanks.

Nice question, thanks.

Stefan Krzywicki (1/30/2014)

---

rodjkidd (1/30/2014)

---

Serious Doh! Moment today.

SSIS process has failed this morning. Business noticed before the support guys. Error says a problem with a column - the files uses ;...

Instead of making your life very difficult, I would make a seperate data flow for each type of flat file.

I think the OP...

You can indeed only choose one option.

If you have multiple destinations for your files, you need to get it in the source query (store it alongside in the table?).

A variable...