i see an approach here that leverages the script task but not being that good at .net dont see how it can be limited to a specific domain controller https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting-task-examples/querying-the-active-directory-with-the-script-task?view=sql-server-ver16

i see an odbc driver at this site but still wonder if our existing sql drivers cant establish this kind of communication?  this looks like an open source product.

https://www.mysql.com/products/connector/

this article describes the crazy workaround where you attach a guid to each record on the 2nd thru nth params to make  them refresh.  https://bpmsbi.wordpress.com/2011/04/23/ssrs-cascading-parameters-refresh-solved/    .

as for stopping my...

• This reply was modified 8 months, 3 weeks ago by stan.

i'd rather have it for each statistical population.   I see you are saying stdev isnt like sum where "group by" limits what you see.  I think i understand.  since i...

that is the question.   what are you suggesting?  how is what you are suggesting done?  are you suggesting 6 selects?  the number of statistical populations varies based on the filter...

• This reply was modified 8 months, 3 weeks ago by stan.
• This reply was modified 8 months, 3 weeks ago by stan.

thx jeff.   eventually i did do the divide and conquer thing.  it took the query down from 6 minutes to 19 seconds.   i turned it over in that state to...

thx adi, didnt find the word trivial in the xml version of the plan.

thx frederico.   i never take those suggestions seriously until i should.

i profiled the volumes on each table and view next looking for a silver bullet.

i went to the plan next...

• This reply was modified 8 months, 3 weeks ago by stan.

thx scott that approach gives the same results (ie no suggestion) i got clicking the "display estimated execution plan" icon upper left in ssms.

this looks simpler.  may try it.  https://stackoverflow.com/questions/13627337/read-excel-cell-values-with-ssis-script-task   .   not sure if sheet has to be a table or not in order for the select statement to work.

just saw the age...

• This reply was modified 9 months ago by stan.

i found this https://www.techbrothersit.com/2016/04/how-to-read-cell-value-from-excel-by.html .   it iterates i believe thru an ado list of cells to extract.

lots of code (even beside the loop) to read a handful of cells.   and...

thx phil do you mean data flow in the cloud service or more down to earth as in ssis?   i noticed in a separate post you mentioned an ssis script...

nice.  simple.  works.   thx

• This reply was modified 9 months ago by stan.

thx jeff, their product gets installed on our sql server.   various related objects are then defined on our sql server under that product.  thru these objects, yes , we send...

i posted a how to question for this at https://www.sqlservercentral.com/forums/topic/dont-see-a-file-system-task-approach-to-copying-excel .    i was hoping to avoid copying content by using the file system task.