Morpheus7
asked on
SSIS CDC Task
I have created a package that uses CDC. We are running SQL Server 64 bit Standard Edition. We have applied SP 1 to release the functionality of CDC for the Standard edition.
Debugging in BIDS works fine, but when running on the server via schedules task, we get the following error:
CDC Control Task cannot run on the installed version of Integration Services. It requires Enterprise Edition or higher.
Anyone know a way around this?
Any help would be appreciated
Thanks
Debugging in BIDS works fine, but when running on the server via schedules task, we get the following error:
CDC Control Task cannot run on the installed version of Integration Services. It requires Enterprise Edition or higher.
Anyone know a way around this?
Any help would be appreciated
Thanks
To be clear, you are saying you have SQL Server 2016 SP1 and still not working? If no, there is no way around as only in Enterprise for versions before that.
ASKER
Yes, we have SQL Server 2016 SP1 and its not working. The reason we use 2016 so we could make use of CDC. All works fine in BIDS it does exactly what it's supposed to. When run on the server via scheduled task, it fails. Using verbose logging, it returned the regarding SSIS.
You also can check if you have the latest version of the component. I haven't been working with the CDC Task specifically but have been in and out of SSDT projects and have had to update it in both my versions of Visual Studio lately. Given CDC doesn't get enabled for Standard Edition in service pack 1, it would stand to reason that there may need to be an updated component but maybe I'm wrong on that.
Hmm. I guess they added the ability to use CDC to 2016 SP1 Standard Edition but not the SSIS capabilities.
https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server
https://docs.microsoft.com/en-us/sql/integration-services/integration-services-features-supported-by-the-editions-of-sql-server
ASKER
I think I must be missing something here. When debugging the package using BIDS on my pc, I am connecting to the same servers that are used when the package is run on the server. It works as it should.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Many thanks Kevin, guess I'm going to have to rewrite the packages.
Yes, sorry it was bad news but glad we could help. I know from experience it is often worse to continue beating your head against the wall trying to make something work because "it should" when you could begin to find another way and close project. Good luck with the rewrite and have a great day.
Happy coding!
Kevin
Happy coding!
Kevin