June 29, 2017 at 3:07 pm
I posted this in AS group, but perhaps it's belongs here... Hello, I have created a tabular cube in 2016 format, and I've created a pkg that executes a query on the source external db, and loads into the target table on SQL Server. What are the objects and any coding I may need to simply load the data from the newly loaded SQL Server table into the cube? This would be a first time load. I'm turning a query and its results and turning into a regular running cube. I would like to also empty the cube for each run. Any help is appreciated. Thanks
June 29, 2017 at 4:39 pm
Please let me add, I have a good working Pkg that executes the query and loads a table. And I have a new model that I can run manually fine too. What objects do I need to add in the SSIS pkg to trigger the cube to truncate the data in it and then load the cube from the newly reloaded table?
June 30, 2017 at 7:58 am
Wanted to follow up, I connected an AS Processing Task to it, setup the connections to the model to process, which had the DSV in it to load, and as a full process to clear old data, tests out and works as intended.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply