All the SSxS (SSIS, SSAS, SSRS, SSMS).

SSDT and BIDS.

CDC (change data capture)

sa

dbo

mdf

ndf

ldf

These are the first that pop into my head.

How are you so sure OLE DB doesn't support it?

What errors do you get?

It might be necessary to edit the mapping files located in C:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles.

A join will not work, as it cannot incorporate the logic that you need results sets in groups of 5.

You can try to write a LEFT OUTER JOIN, and then...

It looks a lot like a newsletter style report (at least for the notes field).

http://blog.hoegaerden.be/2012/11/01/creating-multiple-column-reports/

rmudway (11/6/2012)

---

Did anyone see my question earlier?

Well... i dont need the historical data too be that fast, so it can reside whereever SQL puts it. But i do need the...

rmudway (11/6/2012)

---

sanket kokane (11/6/2012)

---

in your this case you don't need /PAE option ..as you are using 64 bit machine

I hear you on that one and not like that option/switch very...

Normally I would go for option 1, as it minimizes code duplication.

Although 16 sources are lot, which can give issues if there's memory pressure:

http://www.mattmasson.com/index.php/2012/01/too-many-sources-in-a-data-flow/

And maintaining a UNION ALL with 16...

I see you use the parameter...

Are their problems with the query?

What happens if you run them in SSMS (if possible)? Do they succeed?

thedavegray (11/5/2012)

---

Joie Andrew (11/5/2012)

---

Actually if they are not saved I find that SSMS does tend to prompt you if you want to open previously opened Query Editor windows. You get...

Yes, there's only a destination, not a source.

You need to write a script component as a source to read from the object variable where the recordset is stored in.

Somehow using...

Nice question, thanks!

I wouldn't consider this the last option....

Validation can take a long time if some connections are slow or do not respond at all.

If a connection cannot be made, the validation process waits for a time-out.

Ells (11/5/2012)

---

I too am on the hunt for hardware for this. My old laptop is XP. Looking at a laptop with Windows 8 and 8 Gig RAM. I think Hyper...