Dinesh's Blog :::: Being Compiled ::::

Showing posts with label bcp. Show all posts
Showing posts with label bcp. Show all posts
Friday, August 4, 2017

bcp error - Invalid column type from bcp client for colid 1 - Solution

›
You might be experiencing the following error with bcp when loading text data to SQL Server table; It is possible to see this erro...
Monday, July 31, 2017

SQL Server bcp error - String data, right truncation

›
We generally expect a proper row terminator with files loaded using bcp  and with all accurately defined switches, data should be loaded w...
Wednesday, May 24, 2017

SQL Server bcp Error - Unexpected EOF file encountered in BCP file

›
Here is another issue I experienced today with bcp utility (see my previous post related to this:  SQL Server bcp Error - Invalid ordinal ...
Tuesday, May 23, 2017

SQL Server bcp Error - Invalid ordinal for field in xml format

›
We still use bcp  utility for importing or exporting data, specifically when we have to work with large amount of data (I have written pos...
Thursday, March 5, 2015

How to load/insert large amount of data efficiently

›
Importing data from other sources is a very common operation with most of database solutions as not all data cannot be entered row-by-row....
›
Home
View web version

About Me

My photo
Dinesh Priyankara
Colombo, Sri Lanka
Dinesh Priyankara (MSc IT) is an MVP – Data Platform (Microsoft Most Valuable Professional) in Sri Lanka with 16 years’ experience in various aspects of database technologies including business intelligence. He has done many local and foreign business intelligence implementations and has worked as a subject matter expert on various database and business intelligence related projects. He is the Founder/Principal Architect of dinesQL (Pvt) Ltd and he consults, teaches and runs training programs on data related solutions and subjects.
View my complete profile
Powered by Blogger.