If your package is so big, it is better to split it up in smaller packages. This is more manageable and it makes the guy who comes after you not...

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...