I was creating an SSIS catalog at a new project, but I was greeted with the following error message when I hit OK:
The path to the catalog backup file could not be determined. Integration Services might not be installed on this server, or the user may not have the appropriate access permissions.
My initial reaction was something like this:
Why? Because I was sure SSIS was installed and I am an admin on the machine. A typical case of “the error has nothing to do with the issue, whatsoever”. Luckily I came across this Twitter conversation while googling for the error:
And lo and behold, I was indeed using the wrong version of SQL Server Management Studio. Whoops. I quickly switched to SSMS 2014 and indeed, the issue went away.
I loaded some built-in sample data from Wide World Importers into a Fabric warehouse. You…
It was great being at dataMinds Saturday 2024 this past weekend. A great crowd of…
Today I was having a nice discussion with some colleagues about Fabric and pricing/licensing came…
I recently purchased and read the book Deciphering Data Architectures - Choosing Between a Modern…
A while ago I had a little blog post series about cool stuff in Snowflake. I’m…
I have the pleasure to announce I'll be presenting at two conferences this spring. The…
View Comments
This was exactly my issue - switching to SSMS 2014 immediately fixed it! Thanks!!!