Browse by Tags

Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column"

Published 2 June 8 4:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Error message when you run the bcp utility to copy a result set of a stored procedure that...

Filed under: sql server, kba, stored procedure, bcp, dynamic query, error message, dsql

Best option to choose when importing data from a text file where heavy inserts and updates are involved!

Published 8 November 7 1:49 AM | SSQA.net

A specific task of importing data from a text file or any data source where heave inserts and updates are involved is quite common scenario in any SQL Server platform. So when you need to perform such actions on regular basis you need what's the best...

Filed under: sql server, ssis, dts, best practices, etl, bcp, data files, integration services

FIX: Error message when you use the "bcp_sendrow" function in a SQL Server 2005-based application that uses a SQL Native Client provider: "For BCP, all variable-length data must have either a length-prefix or a terminator specified"

Published 27 October 7 9:45 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, error, kba, function, bcp, native client, length-prefix, terminator

FIX: Error message when you use the SQL Server Native Client OLE DB provider to connect to an instance of SQL Server 2005: "Conversions not allowed using bcp_moretext"

Published 16 October 7 3:26 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you use the SQL...

Filed under: sql server, instance, kba, oledb, bcp, moretext, native client, errorr message

FIX: Error message when you use the Bcp.exe utility together with the queryout option in Microsoft SQL Server 2005: “BCP host-files must contain at least one column”

Published 30 August 7 1:45 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, kba, service pack2, column, bcp, queryout

Error = [Microsoft][ODBC SQL Server Driver]Unexpected EOF encountered in BCP data-file

Published 28 August 7 10:10 AM | SSQA.net

When you use BCP then you would definelty get to see this error "Unexpected EOF encountered in BCP data-file". Not only that I have seen this as one of the frequently asked questions (FAQs) and for a moment you might be thinking why there is...

Filed under: sql server, i/o, import, file, bulk-logged, destination, bulk insert, source, bcp