Other SQL Server Blogs around the Web

Browse by Tags

• best practices
• bulk insert
• bulk-logged
• column
• data files
• destination
• dsql
• dts
• dynamic query
• error
• error message
• errorr message
• etl
• file
• function
• i/o
• import
• instance
• integration services
• kba
• length-prefix
• moretext
• native client
• oledb
• queryout
• service pack2
• source
• sql server
• ssis
• stored procedure
• terminator

• 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"

  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... Posted Jun 02 2008, 04:01 AM by SSQA.net Filed under: sql server, stored procedure, kba, bcp, dsql, error message, dynamic query

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

  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... Posted Nov 08 2007, 01:49 AM by SSQA.net Filed under: sql server, ssis, dts, best practices, bcp, data files, integration services, etl

• 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"

  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... Posted Oct 27 2007, 09:45 AM by SSQA.net Filed under: sql server, error, kba, bcp, function, native client, terminator, length-prefix

• 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"

  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... Posted Oct 16 2007, 03:26 AM by SSQA.net Filed under: bcp, instance, errorr message, moretext, native client, sql server, kba, oledb

• 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”

  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... Posted Aug 30 2007, 01:45 PM by SSQA.net Filed under: sql server, kba, column, service pack2, bcp, queryout

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

  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... Posted Aug 28 2007, 10:10 AM by SSQA.net Filed under: i/o, sql server, bulk-logged, import, bulk insert, file, destination, source, bcp