SSIS Package failed in BPC

[Former Member]

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.

Facundo

[former_member208963]

Hi, Do have you configured the Connection Manager to de Database succesfully?

Do you test your query first in SQL manager?

You're doing a OLE DB Source task?