BPC Task Convert - output file not created

[Former Member]

Hi all,

I have been asked to look at an SSIS package that loads data to BPC.  Not really worked with BPC before, but have SSIS experience.  We appear to be having problems with the [BPC Task Convert].  The [Input File] and [Output File] parameters are populated, the task runs and return success, but the .tmp file is not created.  This then causes problems in the next task as the file is referenced and does not exist.

Does any one have any ideas where this might be going wrong?  The package is being run from VS at the moment and I have verified that my user has permission to create files - in fact the source for this task is created earlier on in the package.

Any help or advice much appreciated.

Dave

[Former Member · Accepted solution]

Just thought it worth posting how we resolved the situation....after much deliberation we decided that the dlls that SSIS for the custom BPC tasks...the tasks started to work when executed from BPC, but wouldn't execute from SSIS - by moving the user who the tasks were executing under in SSIS into the BPC admin group all now works correctly.

Thank to Santiago for his assistance.

Dave

[Former Member · Accepted solution]

Excellent Dave!

Thanks a lot for sharing the solution.

Best regards,

Santiago R.

[Former Member]

Dave,

taking a look to my solution, i have found that the files must be under the emvironment\model folder.

Here is my configuration (assuming my environment name is FC_ENV):

Input file:

C:\PC_MS\Data\Webfolders\FC_ENV\Consolidation\DataManager\DataFiles\

Output file:

C:\PC_MS\Data\Webfolders\FC_ENV\Consolidation\DataManager\DataFiles\

Transformation file:

C:\PC_MS\Data\Webfolders\FC_ENV\Consolidation\DataManager\TransformationFiles\

If the files where not in the corresponding folder, the package would run with success but doing nothing.

Hope this helps.

Kindest regards,

Santiago R.

[Former Member]

Thanks again Santiago,

forgot to mention that the task works fine in the DEV environment, but not in PROD - so the folder structure should be fine but after trying several more things today we have still not managed to resolve the issue.  Both environments are identical as far as we can ascertain and we have validated that the a/d account running the job has appropriate permission on the server and in BPC.

We are looking to reregister the ddls involved tomorrow, but after that are starting to run out of ideas......any other ideas ?

Dave

[Former Member]

Hi Dave,

i think you must populate the [Transformation file] parameter also.

I my case it is working perfectly like this:

-One "BPC Task Convert" with a transformation file that adds some columns to the data and changes the column names

-One"BPC Task DumpLoad" that loads the fact data into BPC.

Here you will have more information about transformation files:

Data Transformations - SAP Documentation

Sample Transformation File - SAP Documentation

Hope this helps.

Kindest regards,

Santiago R.

[Former Member]

Thanks Santiago,

looking further - the task does reference a Transformation file, this is
populated at run time using expressions. I have also created a temp package and
removed the dynamic population but it still does not create a tmp file in the
location stated.

So - I now have a task populated as below

- Input File: Points to a file that contains the data to be loaded

- Output File: Holds the location and name of the file to be created

- Transformation File: Points to a transformation file that holds the rules
to be used when creating the Output File

When run - the task shows as green (ie completed successfully) but still no
file is created in the location specified.

Have you encountered this issue before or am I populating something
incorrectly.

Dave