Stage to SSIS to SSAS timings #1251
TinyTimothy2
started this conversation in
Data Modeling
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I stage all data to SERVER1
I use SSIS package to move data from Stage table to SSAS Server. So all the transforming already done. Just strait pull of a table
SSAS Server is on SERVER1 also
I create SSIS package on a remote server.
If execute the project/packages from the remote server, is there anything that would increase the time for SSAS processing of table/model?
I initially thought since all the connections in SSIS connection manager determine the path, that the data would only move from Stage to SSAS, with SSIS package essentially just issuing the command. I now wonder if the data travels through SSIS on a different server.
Thoughts?
Is there a way to track the path and time data is traveling?
Has anyone experimented changing the package size length?
Beta Was this translation helpful? Give feedback.
All reactions