Thanks for the article. I too have wondered about the 'features' that Microsoft has in their SSIS objects. I just completed my first large SSIS project and ran...
There are times when an index is not needed for a foreign key. If the table is small (low number of rows) or the index column has little selectivity,...