December 27, 2013 at 2:26 pm
Hello,
Could anyone tell me if you can dynamically populate the CDC Source values?
My boss wants me to come up with alternatives to our CDC transfer process and I was looking at SSIS but creating separate tasks for every table does not seem feasible for me.
Thank you very much,
Josh
December 28, 2013 at 8:47 am
CDC configured on SQL database and tables. So you will be able to get the list of tables which is part of CDC.
Table cdc.change_tables returns list of all the tables which is enabled for data capture.
Next step you could create a dynamic tsql to get data from all the underline CDC tables.
You can try this option, if this works 🙂 for you..
December 30, 2013 at 2:13 pm
Thanks.
That is exactly what the current process is doing. I was just trying to explore other options to see if there is anything better out there.
December 30, 2013 at 2:33 pm
SSIS doesn't like dynamic metadata, so you can't really use the basic tools in SSIS for something like that, you'd have to create source/targets for each table.
There are some third party tools/components you can review, but I don't have any I'd recommend offhand, as my current shop for the last few years has basically outlawed them.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 30, 2013 at 3:08 pm
Thanks Craig.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply