Recent content by MuadDubby

Thx PRPhx, but no. I'm using the SqlBulkCopy class, as mentioned in the title. It might be using a regular bulk insert in the background, but I have not seen a way to pass an error file name to the bulk copier. MuadDubbby http://cookingwithcsharp.blogspot.com

Hi Every now and then I run into cases where I'm doing a bulk copy and the it is terminated with an exception due to some primary key violation, foreign key violation, constraint violation, etc. The violations are valid and need to be looked into, but what I can't figure out is why the...

Hi Litton1 Thx for the response. I ended up being able to use the immutable types, and created an implementation of a string enumerator. If you're interested in the enumerator code, you can take a look at: http://cookingwithcsharp.blogspot.com/2007/12/999-c-string-enumerator.html MuadDubbby...

C# does not have built-in support for string enumerators, but here is a good way to make one that is relatively simple, does not use reflection, and provides all the same functionality that regular enumerators do: http://cookingwithcsharp.blogspot.com/2007/12/999-c-string-enumerator.html...

Addendum I've considered using immutable types (simple example: http://blogs.msdn.com/abhinaba/archive/2006/12/21/creating-immutable-types.aspx), but the problem with those is that in my case I need to be able to set properties on the object without re-instantiating it every time. But if I...

Hi I'm trying to create a class that will support a deep copy when using the assignment operator, much like how the string class does it. Normally speaking, the assignment operator will create a reference copy of the object, which means that both the original and new object point to the same...

Hi Alex I just finished polishing up an article on this. You can see it (along with a sample project that shows how to do this) here: http://www.codeproject.com/useritems/MSAccessTableCopyInCSharp.asp

Minor correction to the C# code (Access doesn't shutdown properly otherwise): finally { // Quit Access and clean up. oAccess.CloseCurrentDatabase(); oAccess.DoCmd.Quit(Access.AcQuitOption.acQuitSaveAll); System.Runtime.InteropServices.Marshal.ReleaseComObject(oAccess)...

Ok, I think this nightmare has finally come to a close. Several points: 1) I agree that Access should not be used. But you know how hard it is to change legacy apps and procedures. It'll change, but not today. The customer has been using Access since the age of the dinosaurs (give or take a...

Not a bad idea, except that doesn't work within the context of my project. The project is a 100% c# program that takes data from SQL Server, applies some business rules and transformations to it, and then dumps the results to a new table. Several tables are processed in this fashion, and when...

Alex, I'll keep you posted. BCP seems to be out of the question since a BCP export from SQL Server can apparently only go to a text or BCP binary file. I've found no way to use MS Access as the destination. My hopes are still on SSIS, but they're shrinking faster that the polar ice caps.

Sure. Here's one: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=708888&SiteID=1 Just go to Google and search for "fastload oledb". The above link is the first hit.

Hmmm ... Ok, at least that narrows it down a bit. No wonder I couldn't get this to work :) Thx for the answer!

Hi Alex Thx for the response. Everything (dbase, Access file) is local. No UNC or drive mappings in use. I don't have access to the dbase right now, so can't really remember exactly what the layout is. But simply put, it's about six fields long, mostly nvarchars. The package itself doesn't...

One thing I've found so far ... I've seen mentions of a "FastLoad" option that could supposedly be used on the connection string to MS Access and help speed things up. Thing is - I can't get a working connection string with this. If I add it, I'm told that the installable ISAM could not be...