migrating ssdt project from visual studio 2012 to 2017 cdc source not opening
We migrated packages from Visual Studio 2012 to 2017 There is no cdc source component in the ssis toolbox:
and the cdc source component looks like:
And cannot be opened as well.
If I create a new Visual Studio 2017 Project it has the cdc source component in the ssis toolbox:
and I can work with it:
Solution
I was researching this issue a bit and found that some people have success migrating packages by just changing the target version of the packages from 2012 to 2016. Have a look at this blog post to see it in action.
- How to create Tab Delimited Select statement?
- Remove specific data along with the angle brackets in SQL
- Nested SQL Server cursor has no records
- Error when clicking on button to save value in database
- Result order of string_split?
- How do I get a list of stored procedures from a linked server?
- Get distinct related values based on matching value
- SQL Server ignores indexes
- Handling transactions divided by GO statement
- Why can't I re-authenticate (MFA with mssql extension for VS Code)?
- Deploying Umbraco 13 app to Azure app service issue
- Running total for stock left for each month
- Calculate Mashed Potatoes Percentage
- How to use Windows authentication with the Scaffold-DbContext command?
- sql server data fields nvchar(x) or nvarchar(max)
- Convert tables with "id,attribute,value" columns to "id,attribute1,attribute2,..."
- How to limit the SQL Server Developer edition to the Standard edition?
- SQLx to Mssql connection string
- How to create sequential ID's per user in Postgresql
- Select row, check condition and update versus update row where condition
- Filtering on an object/casted column?
- Join tables, between column and attribute in xml data
- SSAS cube processing error about column binding
- SQL Server 2012 error: object reference not set to an instance of an object
- Function to Calculate Median in SQL Server
- No built-in function in SQL Server for "substring to the end"?
- Multiplication aggregate operator in SQL
- When are curly brackets required when used in a XQuery in SQL Server?
- SQL query for search user using combine FirstName and LastName column
- Trying to write dynamic sql and export results to a text file