Package migration from version 8 to version 6 failed with error
I have a basic package that includes a couple of Exec SQL Tasks and a Data Flow task. It was developed using Visual Studio 2019 (latest edition as of now), in package deployment model. The execution in VS works perfectly but fails when ran by SQL Agent (within SQL Server 2012 Standard) because of this error
"Package migration from version 8 to version 6 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version number.". "
What I've tried:
1- I've already read through all other answers to this same question: I went through Properties and then Changed Deployment Version from 2019 to 2012. In fact, I get this confirmed:
2- I went through XML and ensured that there is no such thing as Version 8, and it is only in V6 3- I recreated the whole thing again using Visual Studio but this time I started with the deployment target set as 2012.
Please help. Thank you
I thought I'd answer in case someone else is struggling: the issue is due to a fundamental design flaw within VS (it is stupid how they designed it without considering this). In essence, I was using connection types (drivers) that are not supported in the earlier versions. Connection types rarely get version upgrades (say for instance SQLN11 vs. 10). All you get when you get the target server is a different XML schema, it does not change the connection type to a SQL 2012 friendly version.
I changed the connection types manually by recreating the whole package using VS 2012. It worked. But if you have earlier versions of the connection types, you don't have to do this, just choose the earlier ones if it allows you to.
- Query to find position in a string before keyword and extract data before that position
- Correlate these tables dynamically (or automated)
- Manage the order of updates when using a filtered unique index?
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Can we use SQL Server STRING_AGG() in queries using GROUP BY ROLLUP ()
- What are row, page and table locks? And when they are acquired?
- Aggregate into custom groups
- Work with multiple where statements with different conditions
- Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
- How can I find sql server port number from windows registry?
- SSIS OLE DB Destination Editor - Create New Table not an option?
- How to Apply Gridify Filtering on an ICollection<T> in EF Core?
- SQL Server Cursor vs WHILE loop
- How do I control parameter sniffing and/or query hints in entity framework?
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?
- using Object_id() function with #tables
- Conditionally filter results of query based on a single flag
- Fill down from a specific row based on criteria
- Spark sending LIMIT to SQL Server on display function
- database restore failing with move
- Join column from a table in SQL Server without write permissions to a data.frame in R using dbplyr
- different deleting OUTPUT behaviour based on source table
- How to simulate a deadlock in SQL Server in a single process?
- Is "SET NOCOUNT OFF" necessary in a stored procedure?
- EF Core takes a lot of time, sometimes, to perform SELECT query
- Dynamic T-SQL - Alter column definition to max length of field
- SQL Server: Update table based on JSON
- Best index(es) to use for an OR Statement in SQL Server
- In a select with a group by, get the last value of a column not in the group by