Comments (12)
Are you in project deployment model (deploy to SSISDB) or package deployment model?
When you look at project properties what is the TargetServerVersion you are deploying to?
from bideveloperextensions.
Thanks for getting back to me so quickly!
We have not gotten far enough with our project planning to make a definitive decision on the deployment model, but so far they have been deploying packages as files to their server, so my guess is that they are intent on using package deployment.
As for the TargetServerVersion, it is pointing to SQL Server 2017. I tried updating the value to SQL 2014 but it gave me a warning saying:
You are about to change the TargetServerVersion property to SQL Server 2014 of this project. If your project contains extensions that are not supported nor installed in SQL Server 2014, your packages may not be run properly.
It is highly recommended to:
- install all the needed extensions for SQL Server 2014 and
- back up your project before you proceed with this change
VS doesn't provide any further information on that, and when I go to Extensions and Updates, I do not see anything that corresponds to "SQL Server 2014" specifically. Also, on my local machine SQL 2014 is currently installed and functions normally. I tried looking for "install all the needed extensions for SQL Server 2014" in google and did find this...
... though I'm not sure if this is obsolete or the correct installation to use. Can you advise us on this as well? Thank you!
from bideveloperextensions.
Do you have custom SSIS components or tasks installed and used in your packages? If so which ones?
from bideveloperextensions.
I'm pretty sure the answer to that is no, but I didn't create the package, so I'm only 99% sure. As far as I can tell it's using the standard SSIS components and tasks.
The puzzler for me is that when I try to find "SQL Server Data Tools 2014" I do locate this page:
https://docs.microsoft.com/en-us/sql/ssdt/previous-releases-of-sql-server-data-tools-ssdt-and-ssdt-bi
... but it appears that 2014 is actually skipped over, which makes the message from Visual Studio confusing.
from bideveloperextensions.
Update... after further research we decided to go with Project Deployment. I didn't attempt to do an install of the SSDT 2014, but was able to change the TargetServerVersion to 2014 after ignoring the warning. I was able to deploy the package to our development SQL Server 2014 into SSISDB. No problems surfaced.
So that's the current state. We still get the same error when attempting to use the Design Warning Scanner. Thanks for any help you can offer! We're looking forward to using that feature!
from bideveloperextensions.
Still hoping we can get some guidance on this. It is still not working for us. Any advice would e greatly appreciated. Thanks!
from bideveloperextensions.
It's likely a BI Developer Extensions bug for this specific situation. It's on the list of bugs to look into and fix and we will update the thread as we have time. We all have day jobs so please be patient as there are many other items requiring our attention.
If it's urgent to you then feel free to download the source code and debug yourself further and create a pull request with any code changes you deem necessary.
from bideveloperextensions.
Ok. I see. Not a problem. Thanks for the utility even if it does have a bug or two. It's great. Looking forward to whenever you can get to this item. My hope is that we can use it to identify items that have been created in the packages that are not being used, and/or are creating conflicts within the packages. Thanks again. Great job!
from bideveloperextensions.
Is this still an issue with the latest BI Developer Extensions 2.3.0 release and with the latest SSDT 15.9.0 install (SSIS extension 2.1 or 2.2 in the Tools... Extensions and Updates dialog)?
from bideveloperextensions.
I have SQL Server 2022. It is my local database.
I am using SSMS 18.12.1.
I want to create new job, but when I try to add "new step", I encounter the same error:
"Unable to find the directories containing Tasks and Data Flow Task components. Check the integrity of your installation."
I uninstalled SSMS and reinstalled it, but the error still persists.
Is it version mismatch or something ?
from bideveloperextensions.
I have SQL Server 2022. It is my local database. I am using SSMS 18.12.1. I want to create new job, but when I try to add "new step", I encounter the same error:
"Unable to find the directories containing Tasks and Data Flow Task components. Check the integrity of your installation."
I uninstalled SSMS and reinstalled it, but the error still persists.
Is it version mismatch or something ?
@erenirmak i donβt think this has anything to do with BI Developer Extensions right?
from bideveloperextensions.
I don't know what causes it, but I couldn't find this error on anywhere except here.
Is there a common component used in both SSMS or SQL Server 2022/SQL Agent and BI Developer Extension?
from bideveloperextensions.
Related Issues (20)
- BIDS Helper encountered an error when Visual Studio started after update HOT 3
- Expression window does not work HOT 1
- Method not found exception - VS 2019 - SQL Server 2019 HOT 1
- Dimension Data Type Discrepancy Check Context Menu Missing HOT 5
- Roles Report is not offered HOT 2
- VS2019 and SSAS "Deploy MDX Script" error HOT 1
- sync descriptions error - method not found HOT 1
- BI Developer Extensions hanging Visual Studio while walking installed extensions on UI thread
- Update Estimated Counts Missing Again HOT 1
- How do I upvote this thing
- Visual Studio 2022 HOT 9
- Expression Editor pops up when accessing the variable window description field. HOT 1
- Extension not loading in VS 2019 after install HOT 1
- Variables Window Extensions Not Visible HOT 3
- "Deploy Mdx Script" fails because assembly for Microsoft.AnalysisServices.Design can't be loaded HOT 4
- Printer Friendly Dimension usage on the latest version of SSAS cause an "object reference" error HOT 1
- BIDS Helper encountered an error when Visual Studio started HOT 3
- Version 2.4.1 and Microsoft Visual Studio Community 2019 Version 16.10.0 HOT 3
- BI Developer Extensions for Visual Studio 2022 HOT 5
- Web page link to [ORAYLIS BI.SmartDiff] is broken on https://bideveloperextensions.github.io/ site.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
π Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. πππ
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google β€οΈ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from bideveloperextensions.