Use SSIS to get measures from a tabular model
You cannot get the value of a measure without an evaluation context. You can however execute a DAX query to fetch the data that you need. Once you have defined your connection manager, instead of choosing Table or View as your data access mode, choose SQL Command. You can then specify the DAX Query which will evaluate the measure within your defined context. After you have defined your query you can click on the Preview button to see the data that will be returned.

You can find a step by step guide on how to do this here.