SOLVED. Thank you guys for your responses, but this was basically a stupid user exception.

The problem had after all nothing to do with the Windows account (as you probably suspected)....

I have always managed to get rid of metadata errors simply by running the project in BIDS step by step. When all previous steps have been executed, open the input...

Hi,

how can you give a Windows account bulkadmin/sysadmin role in SQL Server so that it is used when running a SSIS package via dtexec?

I tried adding a login in SQL...

Hi and thanks for the response.

I understand that my Windows account is used for running the package. Yet I can access the required files and do the bulk load and...

In database engine I have sysadmin role but when one connects to Integration Services (instead of Database engine) Windows credentials are used. I have gathered that the packages are actually...

Hi,

I don't know if the SSRS version is of importance here - I'm using SSRS 2008. Anyways, I initially had the same problem with all extra sheets beginning with an...