SAS with BULKLOAD=Yes: ERROR: BCP initialize error: Unable to retrieve error message

Error handling in sqlbulkcopy / continue on error

Slightly different approach than already suggested; Perform the ...SqlBulkCopy... and catch the ...SqlException... thrown:... Violation of PRIMARY KEY constraint 'PK_MyPK'. Cannot insert duplicate key in object 'dbo.MyTable'. **The duplicate key value is (17)**. ...You can then remove all items from your source from ID 17, the first record that...

Using the WHERE clause to read an Excel file with blank rows causes an unknown error.

So clients upload Excel files to us and we have a windows service that periodically grabs new files and bulk-loads the contents to our SQL server like so:...string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties=\"Excel 12.0;HDR=YES;\""; using (OleDbConnection excelConnection = new OleDb...

DBF Errors in C# BulkCopy (Timout, & Provider could not determine...)

I've written a small console app that I point to a folder containing DBF/FoxPo files....It then creates a table in SQL based on each dbf table, then does a bulk copy to insert the data into SQL. It works quite well for the most part, except for a few snags.. ...1) Some of the FoxPro tables contain 5000000+ records and the connection expries before ...

"ERROR: extra data after last expected column" when using PostgreSQL COPY

Please bear with me as this is my first post. ...I'm trying to run the ...COPY... command in PostgreSQL-9.2 to add a tab delimited table from a .txt file to a PostgreSQL database such as:...COPY raw_data FROM '/home/Projects/TestData/raw_data.txt' WITH (DELIMITER ' '); ...I've already created an empty table called "raw_data" in the database using t...

Insert xml data into SQL server via SqlBulkCopy with powershell (casting error)

I'm getting a "cast not valid" error when trying to insert a data table containing xml using sqlbulckcopy....I cast the DataColumn that will hold the xml data to type System.Xml.XmlNode is that incorrect? Looking ...here... it just says the .NET Framework type is xml. ...Here is an example of the xml I want to insert:...<Event xmlns="http://schemas...

Cannot SQLBulkCopy Error 40197 with %d code of 4815 (Connection Forcibly Closed)

Developing with VS 2013 ASP.NET MVC 5 Web Project and Separate Azure hosted SQL Server database. ...At the bottom is all my error information from Visual Studio 2013. I've narrowed down the problem and found a link to the Microsoft Description of the problem without a solution. I'm Developing with Database First and Entity Framework 6. ASP.NET 4 MV...

Error handling in sqlbulkcopy / continue on error

Slightly different approach than already suggested; Perform the ...SqlBulkCopy... and catch the ...SqlException... thrown:... Violation of PRIMARY KEY constraint 'PK_MyPK'. Cannot insert duplicate key in object 'dbo.MyTable'. **The duplicate key value is (17)**. ...You can then remove all items from your source from ID 17, the first record that...

SqlBulkCopy ColumnMapping error CSV to DataTable to SQL Server Table

I am trying to bulk insert a CSV file into a SQL Server database....The process is ....CSV... file to ...DataTable... to ...SqlBulkCopy... to SQL Server....When I run this I get this error: ...The given ColumnMapping does not match up with any column in the source or destination...When I directly import the CSV into SQL Server via Management Studio...

Error with SqlBulkCopy: invalid character but the XML string seems to be valid

I am having an issue with SqlBulkCopy (in c#, framework 4.5.1) where a valid XML string is causing the error System.Data.SqlClient.SqlException: {"XML parsing: line 1, character 29, A string literal was expected"}"...The table is... ...CREATE TABLE [dbo].[JobManager_BigTextTest]( [PKID] [int] IDENTITY(1,1) NOT NULL, [BigXML] [xml] NOT NULL, PK_JobM...

Get the line number on which the request to database ended with an error

I use this code to send a SQL request:... SqlBulkCopy bulkCopy = new SqlBulkCopy(Connection); foreach (DataColumn column in dt.Columns) { bulkCopy.ColumnMappings.Add(column.ColumnName, column.ColumnName); } bulkCopy.DestinationTableName = "nsi." + classifierData.Info.TableName; bulkCopy.WriteToServer(dt); ...and get this exception : ...

Troubleshooting BCP and Format File Errors

First off, sorry for the long post. I wanted to be thorough with my examples/data, and the bulk of this post is just that....I inherited a Bulk Import Process using a format file (.fmt) at my new job. This process was created by the guy that worked here before me, and it is my job to learn this process (and fix it now). I have limited knowledge ...