AnkUser
2021-01-04 22:05:27
This question is generic and subjective. Let me try to add my 2 cents. There might be someone with more expreice who can add more details to your questions.
You asked specifically for 2 options
- SSIS: Do you have license for any of SSIS product. If yes I would prefer this option. Reason: You will have connections already available and most of the SSIS products have drag and drop flows which will perform most of the generic logic. I have some experice with Scribe and I found it easy to use and faster to perform CURD operation.
- C# Console APP: I do code most of my time and I am quite comfortable with C# code. Here the main drawback is you have to write most of the code may it be from connection to Dynamics to get records, perform all the CURD operation and write few lines of code. The more line of code the more chances of making mistake. It takes also some time to write code and test it. But main advantage is you have all the control and can perform most of the operations as you want.
热门帖子
热门github
6
Thank you for your insight. I don't currently have a license for any SSIS product(s). So I was thinking C# may be the better route. But I wanted to see if there was an explicit reason not to use C#. Just so I can better write a question next time, what could I have added to make it less generic/subjective?
could you upvote answer if it helps and if it fines with you could you accept the answer.