sql-servervisual-studiossissql-server-data-toolsssis-2012
Unable to set Target Server Version to SQL Server 2012 for Integration Services Project
I'm trying to create a new Integration Services project. By default the project targets SQL Server 2017. I need it to be SQL Server 2012, but the option is not showing up. I have existing projects which have been set to 2012 a while back, but now I can't do it anymore.
Any clue on why the SQL Server 2012 option isn't showing up? Is it a compatibility issue?
I'm using Visual Studio Community 2017 v15.9.7 with SSDT v15.1.61901.24070.
Solution
Latest version of SSDT is 15.9, maybe updating will resolve? SQL Server 2012 support was temporarily removed in 15.8 though.
- Summation of a column using certain conditions
- Add a value on their SESSION_CONTEXT for all sys.dm_exec_sessions
- Natural join in SQL Server
- How to concatenate text from multiple rows into a single text string in SQL Server
- SQL Server Cursor vs WHILE loop
- SSIS: Insert multiple Excel files with same format but different file name to multiple database table destinations based on the Excel filename
- Seeking Advice on Efficient Data Unpivoting in SQL Server with SSIS or Alternative Tools
- SQL-How to Insert Row Without Auto incrementing a ID Column?
- Why can't I use an alias in a DELETE statement?
- Can ransomware encrypt a mounted SQL database? Hypothetical
- Grant user DDL permissions on specific schema
- How do I perform a GROUP BY on an aliased column in SQL Server?
- Collecting data from a joined table based on condition(s) in the joined table
- Stored procedure for auto generating roll no?
- Is there any way to get lcid of current session in a function with schemabinding option?
- How to find databases which accessible to me in Sql server?
- Default encoding in SQL Server Management Studio
- Database stuck in "Restoring" state
- Unable to open BCP host data-file
- How to join parent object with nested array using OpenJson SQL
- Efficient paging with Repeater, SQL Server and custom Pager
- Queries using LIKE wildcards in sql server
- Conditional aggregation in SQL: display condition-dependent count in percentage?
- What would be the ideal way to do paging using a Infragistics WebDataGrid and SQL Server 2008
- output sql data to html with hyperlink
- Update all column names to be lowercase
- Connect python-polars to SQL server (no support currently)
- SQL Server pivoting on data without an aggregate
- replace or remove characters and then cast to decimal
- Query to get only numbers from a string