or she would create a new account and...

and this is a lot easier to do in Powershell - which could be called from SSIS directly if "boss" insists in SSIS

variables could be passed from ssis or from...

As Phil said it seems correct.

so in order to test it to ensure that the 2 queries work the same way test the individual selects in isolation of the proc...

what attempts have you made so far?

that is a fairly simple case of replacing with a combination of "and" and "or"

no real good reason then to refuse to host it on that...

that means that on that particular cube one of the tables has a record that exceeds the max of 64KB

you will need to identify what it is and potentially remove...

possible way - not the prettiest and probably not the best one - and not sure if it will work for all periods you may have

code adapted from https://dba.stackexchange.com/questions/174035/split-duration-hourly-depending-on-start-and-end-time

Requirements copied...

• This reply was modified 5 years, 8 months ago by frederico_fonseca.
• This reply was modified 5 years, 8 months ago by frederico_fonseca.
• This reply was modified 5 years, 8 months ago by frederico_fonseca.

you may be suffering from the change to bulk insert since 2016.

have a look at https://techcommunity.microsoft.com/t5/sql-server/sql-server-2016-minimal-logging-and-impact-of-the-batchsize-in/ba-p/385537

if this is the reason you will need to either change your load processes to...

This is akin to asking "whose responsibility is it to provide a quality product"?

Everyone's responsibility should be to make their work the best they can, not depend on other...

from my point of view it should be primarily on the developer - and organizations that do not give the tools to their developers to improve their code are loosing...

you can easily update the code I supplied to flag when a circular happened - I would be pretty sure that that is what is happening to you

potentially outputting the...

Normally when I am working with rCTE I add a column to prevent circular dependencies (which is what normally causes the max recursion error)

example below is to do with Active...

I think it...

According to licensing terms Developer only on a...

same as I gave original - do the data migration yourself without using SSMA