Getting while uploading datatable data to database using sqlbulk copy

[NareshN]

Hi All,


I am getting error while trying to upload DataTable data into Database table using sqlbulk copy.

Format of the initialization string does not conform to specification starting at index 0.

  using (var copy = new SqlBulkCopy(conn.ToString(), SqlBulkCopyOptions.KeepIdentity & SqlBulkCopyOptions.KeepNulls))
        {
            copy.ColumnMappings.Add(new SqlBulkCopyColumnMapping("atnDate", "atnDate"));
            copy.ColumnMappings.Add(new SqlBulkCopyColumnMapping("StartTime", "StartTime"));
            copy.ColumnMappings.Add(new SqlBulkCopyColumnMapping("EndTime", "EndTime"));
            copy.ColumnMappings.Add(new SqlBulkCopyColumnMapping("MatchingOff", "MatchingOff"));
            copy.ColumnMappings.Add(new SqlBulkCopyColumnMapping("CampaignID", "CampaignID"));
            copy.ColumnMappings.Add(new SqlBulkCopyColumnMapping("EmpName", "EmpName"));
            copy.DestinationTableName = "SAR_TimeSheet1";
            copy.WriteToServer(dttblSAR_TimeSheet);
        }