Viewing 15 posts - 1 through 15 (of 543 total)
Again, I still so go and start on a clean environment, going to be your easiest option I think at this stage instead of trying to piece the information...
February 1, 2024 at 9:47 am
I have not deleted the SSISDB but catalog. Sorry catalog was named as SSISDB and hence the confusion.
February 1, 2024 at 9:28 am
I could not create a catalog DB via windows authentication mode. So I am trying to find the other ways to do so.
As far as I can remember,...
February 1, 2024 at 8:28 am
If you cannot get the master key from the original source - then *hopefully* you have copies of all projects in VS so you can redeploy to a newly...
February 1, 2024 at 8:07 am
You can't delete the key.
Go get the old server back, backup the key, restore the key or start the new server again from scratch and reimport all your packages.
That's...
January 31, 2024 at 1:49 pm
Having Access run a stored proc to execute a package deployed to SSISDB is the way to go. Any other way is likely to violate software licensing.
If you don't...
January 31, 2024 at 1:19 pm
So you copied SSISDB from one server to another?
Yeah there's a bunch of steps you need to do to make that happen successfully.
When you first create the catalog on...
January 31, 2024 at 12:53 pm
OK, good. So what is it that you are not able to do, exactly?
Hi Phil,
I just installed SQL Server 2019 Management Studio and found DTExecUI.exe. When attempting to use...
January 31, 2024 at 12:46 pm
In VS2022, if you go to Extensions/Installed/All, do you see the following?
'SQL Server Integration Services Projects 2022'
Yes, I do see it.
January 31, 2024 at 11:50 am
Protection Level is EncryptSensitiveWithUserKey. The exact error is this "Please create a master key in the database or open the master key in the session before performing this operation. (Microsoft...
January 31, 2024 at 11:48 am
You would have to do some analysis of your data and determine where in the hierarchy, if at all, cost group should go. Bear in mind that users can...
February 6, 2020 at 2:12 pm
You have to change the error configuration in the dimension properties to ignore key duplicates: https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/error-configuration-for-cube-partition-and-dimension-processing#bkmk_dupe
This can really mess up your query performance but if it's what the...
January 31, 2020 at 12:56 pm
Because you are attempting to put Cost Group in a position in a relationship where it does not belong. The attribute relationships/keys are how SSAS determines what SQL to...
January 31, 2020 at 12:17 pm
Yeah, now I got your point. I could see why it is many to one. Unfortunately the users wants the cost group to put it in that particular level. How...
January 31, 2020 at 11:59 am
It very much depends on how you have each attribute set up (the key columns and the attribute relationships) but what you have to bear in mind is that...
January 31, 2020 at 10:20 am
Viewing 15 posts - 1 through 15 (of 543 total)