Regarding using SSIS to acquire data the ease is only proportional to the cooperation of the upstream provider and the immediacy of the data is only as valid as the...

@GrassHopper - I don' usually use OPENQUERY and a linked server works better if you have multiple developers who know standard join syntax but are not as knowledgeable...

Nice article. I find in actual use where the person creating the linked server is a company level DBA that providing scripts is a necessary component. Also be aware that...

Indeed you are correct. I am probably just complaining to complain but it is a habit with MS software. So ... my bad. I have a link with a functional...