Skip to Content
author's profile photo Former Member
Former Member

BPC Task Convert - output file not created

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2014 at 01:27 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2013 at 07:41 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2013 at 01:18 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.