BCP Format Files

SQLServerCentral Article

Skipping Columns (& other tricks) Using BCP Format Files (SQL Spackle)

  • Article

BULK INSERT and BCP are powerful, high performance tools for importing text files. SQL Server MVP Jeff Moden gives us several nifty tips in this introduction to BULK INSERT and BCP Format Files including "Skipping Columns" and the sequestration of bad rows while still loading all the good data.

4.78 (27)

You rated this post out of 5. Change rating

2014-01-23

17,199 reads

Technical Article

RE: nt_username in sysprocesses table is blank in one server and not in the other.

  • Reply

Mike:I believe that you are on to something. However, I believe that it has to do with the Server and not with Client.  You said “your tests involved changing the Client configuration only”. Was this on the Client or on the Server? The remote clients do not have the client Network Utility installed on their […]

You rated this post out of 5. Change rating

2004-03-16

Technical Article

RE: SQL Server wont start after backup??

  • Reply

All, Thanks so much for your responses.Based on these two articles http://support.microsoft.com/default.aspx?scid=kb;en-us;814848 and http://support.microsoft.com/default.aspx?scid=kb;en-us;240240 this is our problem. To quickly rap them both up; files and folders have two names associated with them a long name a short name.  Short name are applied as applications are installed.  When a backups is preformed the short name […]

You rated this post out of 5. Change rating

2004-03-12

Blogs

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Snowflake + Azure blob

By

Let’s go back to data platforms today and I want to talk about a...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers