After the following modification to the Dynamic SELECT it works with long tablenames and indexnames.

-- Build SQL to read each page in each index (including clustered index).

SELECT @CheckIndexesSQL = @CheckIndexesSQL...

Nice.

However when i try i get:

Msg 103, Level 15, State 4, Line 117

The identifier that starts with 'TableName: Land.ATL_Tag_TagVidTrafikplats_RapportSomSkaGoras. IndexName: PK_ATL_Tag_TagVidTrafikplats_RapportSomSkaGoras. IndexI' is too long. Maximum length is 128.

The identifier...

Recreated the package once more and now it works.