Hi,

In addition... when You do the "select *" DB still have to grab all the data from disk... If columnstore index would include all columns then in theory this operation...

You can also do additional table with permissions... like this:

tabBudget will contain columns:

[...]

departamentID

cash

date

[...]

tabDeptUserPermissions will contain columns:

ID

departamentID

user

and in reporting services when You pull data from tabBudget do join with tabDeptUserPermissions on...

Check first few records (around 20)... if they are numbers and later (after 4500 rec.) in this columns are strings/dates etc.. (different then this few first records) then SSIS will...