Consider My dynamically generated datatable contains the following fileds ...Id,Name,Mob1,Mob2...If my datatable has this it get inserted successfully,...Id Name Mob1 Mob2
1 acp 9994564564 9568848526
...But when it is like this it gets failed sa...
Update: ...Here is my solution...I have a table defined as:...CREATE TABLE [dbo].[csvrf_References]
(
[Ident] [int] IDENTITY(1,1) NOT NULL,
[ReferenceID] [uniqueidentifier] NOT NULL DEFAULT (newsequentialid()),
[Type] [nvarchar](255) NOT NULL,...
When I am using SQL Bulk Copy, my columns return "null" halfway through the insert... ...The only thing I can think of is because of special characters such as ".../..." and "...-...". Is it at all possible to escape chars in SQL bulk Copy?...I've tried l...