Hi jdurgin1,

Did you ever find a solution to this? I have encountered the same problem while trying to load in files the same way you mention in your post....

Thanks for the code Lowell, I have been playing around with this myself and it looks like it is going to work out well for my problem.

Thanks again both of...

Thanks Steve, this may be an option if we cannot figure out a better way around this. I just need to confirm that we are not allowing ? characters...

I believe it may be related to the constraint....I tried removing the constraint, running the stored procedure, and re-creating the constraint which could not be added due to uniqueness issues...

I was not disputing that SQL Server does not work well, I was simply asking for suggested debugging tips on an issue that seemed to not make sense in a...