Skip to Content
Former Member
Mar 31, 2014 at 01:19 PM

SSIS Package failed in BPC


Hello everybody,

I'm trying run a custom SSIS package by BPC, but it's failed. It's finished with error but his log it's empty. The DM package invoke to custom DTSX which perform a merge join between query a db table and a flat file, and then save the result in a target flat file. If I run the DM package invoking to custom DTSX which have only flat file, this finish successfully. I think that the error It is due to access rights to db. I am setting a sql user with read only rights. If I run the custom DTSX by dtexec or SSIS it finish successfully.

Have you any idea?

Im using SAP BPC 7.0 MS with SQL Server 2008.

Thanks in advance.