Use DTS to export data:
From (Source): MS OLE DB Provider for OLAP Services
To (Destination): Excel file
Downside:
In "Source" part of Transform Data Task properties, it seems that we're forced to use "Table/View" since "SQL query" is quite unusable. (or don't know how to yet?)
Thus we cannot select (filter) data to export.
All we can do is go to Options tab and select which row numbers to export.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment