[CSHARP-1135] CSharpDriver-1.7.0.4714 and CSharpDriver-1.10-rc0 dlls couldn't be registered Created: 01/Dec/14 Updated: 05/Apr/19 Resolved: 01/Dec/14 |
|
| Status: | Closed |
| Project: | C# Driver |
| Component/s: | Setup |
| Affects Version/s: | 1.7 |
| Fix Version/s: | None |
| Type: | Task | Priority: | Blocker - P1 |
| Reporter: | Deepak | Assignee: | Unassigned |
| Resolution: | Done | Votes: | 0 |
| Labels: | driver, question | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Windows 7 (32 bit) |
||
| Description |
|
Hi, Trying to load data from Mongo to SQL 2008 using SSIS 2008. My Mongo source has many embedded documents with a dynamic schema. How to do I load these embedded documents using SSIS? Let me also know if there are any other better option to load embedded documents using SSIS. Thanks in Advance. Regards, |
| Comments |
| Comment by Craig Wilson [ 04/Dec/14 ] |
|
Yes, go back to a version where we strong-signed the dlls for you. Previous versions, however, don't necessarily work with the newer server versions. I would strongly encourage you to simply build them yourself and sign them with a key you or your company uses. Our signing was with a key that was public, so it amounted to providing no security at all. It's easy to do this as all you need is msbuild. Simply pull the source code and run `.\build.cmd Build` and you'll be built. Now you just need to customize the project to include signing. |
| Comment by Deepak [ 04/Dec/14 ] |
|
[We used to strongly sign the .dlls which allowed them to be installed into the GAC. Strong signing is not typically done anymore and caused more problems than it solved as a majority of users do not install into the GAC. As such, if you need to install into the GAC, you'll need to build the .dlls yourself with strong signing enabled.] – If I am not building my own dlls then what are all the other options to use these dlls (drivers - C# 1.5 and above) in my SSIS package to connect Mongo? |
| Comment by Craig Wilson [ 01/Dec/14 ] |
|
Deepak, I'm not sure what you mean by, "load embedded documents." Simply querying for documents will pull back embedded documents and arrays by default. As far as SSIS goes, we haven't played with it. I presume MongoSSIS works, but have never worked with it. This type of question is better suited for our google group (https://groups.google.com/forum/?pli=1#!forum/mongodb-user) or stackoverflow. There are a greater number of users watching those that might be able to answer your question better. |
| Comment by Deepak [ 01/Dec/14 ] |
|
Please advise me how to load embedded documents. Some links explaining these should be great for me. |
| Comment by Craig Wilson [ 01/Dec/14 ] |
|
We used to strongly sign the .dlls which allowed them to be installed into the GAC. Strong signing is not typically done anymore and caused more problems than it solved as a majority of users do not install into the GAC. As such, if you need to install into the GAC, you'll need to build the .dlls yourself with strong signing enabled. |