Hi to all Experts,
I installed BPC MS 10.0 with SQL Server 2012.
I want to do a demo test on Import SQL data into bpc. For this, I searched for how to use Import SQL DM Package.
I created a sql table, and then ran import sql dm package via excel client. I get the following error.
Error occurred while updating the dynamic properties of a package
[dbo].[tblFAC2Copy] is missing or invalid source table.
I know for sure that I am missing some basic configuration in this matter, but could not figure it out.
Note: in Import SQL package properties, ApShell is used. which I think is not correct because I do not have any application with this name.
Any help would be highly appreciated.