How so? I have used it often and it loads data just fine.

How many rows do you need to load and how do you construct your package?

A simple .NET application would be easier I guess.

You have a simple form, people fill in information in a textbox, fill in parameters into other textboxes (or select them from...

That makes more sense...

polkadot (5/11/2012)

---

Koen Verbeeck (5/10/2012)

---

You can create a report in Reporting Services and let it render the report in Excel or in Word.

For users, they would just click on the link...

brian.healy (5/11/2012)

---

I think the moral is you have got to know SSIS in detail, particularly what each task/component does, and the bits that maybe you don't use day-to-day like logging...

Great article! I will use it as a reference for colleagues who still want to do the MCITP.

You can use the standard OLE DB Source/Destination with the Oracle OLE DB provider.

You can create a report in Reporting Services and let it render the report in Excel or in Word.

For users, they would just click on the link and they get...

Great question, thanks.

Stefan Krzywicki (5/10/2012)

---

RBarryYoung (5/10/2012)

---

Koen Verbeeck (5/10/2012)

---

Stefan Krzywicki (5/10/2012)

---

Yeah, I created the import package manually. I ended up getting the table structures by using an openquery in a cursor loop through...

Stefan Krzywicki (5/10/2012)

---

Yeah, I created the import package manually. I ended up getting the table structures by using an openquery in a cursor loop through a list of the Oracle...

sknox (5/10/2012)

---

Not a good excuse, but a very good reason. I remember reading somewhere that the best way to read multiple-choice questions is to skim the question, read the answers...

WayneS (5/10/2012)

---

Hey Threadizens,

Regarding today's (10 May 2012) QOTD: several folks have stated that it could have been worded better. My question to you is how would you have worded it...

Stefan Krzywicki (5/10/2012)

---

We're moving a bunch of Oracle to SQL Server here too, I'm happy that we're doing it, but interacting with Oracle is a pain.

One really annoying bit is...

Daniel Bowlin (5/10/2012)

---

I saw a presentation last year at the Boston SQL Saturday on using the data profiling task to create a meta data definition that could be used later...