A better forum might be the SSAS forum itself (you have to scroll a bit more down):

http://www.sqlservercentral.com/Forums/Forum17-1.aspx

Please read the link in my signature on how to post questions.

In short, we need the following: table DDL, sample data (in the form of insert statements) and desired output.

On...

Nice question Ron, thanks.

There are classroom trainings with that kind of offering, but not sure about online trainings.

If you google for SQL Server top 10 design mistakes you can find some good leads.

Kevin Kline has a session about this, you might find a recording online.

Here are the...

I haven't used them personally, but I know the teachers of the courses are real professionals.

Check out pragmatic works and pluralsight.

No. If your SSIS packages are stored in the MSDB database, you can query them using XML functions.

Here's a starting point:

Collecting information about your SSIS packages

As I said, for SSIS package you'll need to parse the XML file to get the connection manager info.

You mean for documentation purposes?

You'll need to parse the SSIS package to get that information (a .dtsx file is just a XML file).

I'm no DBA myself, but this book has got some good comments:

Troubleshooting SQL Server: A Guide for the Accidental DBA

Data virtualization. It's the first time I hear that term. I know data visualization, but SSIS is certainly no visualization tool.

If it's about data integration, SSIS is really a good...

Nice one. Will probably never use it though 😀

You probably will need to change your design in the database.

Oh boy, if the package already takes 40 minutes to run, the OLE DB will slow it down to a couple of hours.

Furthermore, regarding your statement "... incorrectly suggesting that...