I have not observed this scenario. I have a user "bireader" on a database "BI_DW" that only has SELECT permissions on the tables in that database. This user can still...
If you are using SQL Server 2005, you may also want to consider the new UNPIVOT command. This would move the processing from SSIS to the DB engine, which may...