Advertisement

07.22.2008 at 12:15PM PDT, ID: 23586237
[x]
Attachment Details

Understanding BCP and Format Files

Asked by jdana in MS SQL Server, SQL Server 2005

Tags: Microsoft, SQL Server 2005

I'm in the process of familiarizing myself with the format file option (-f) with the BCP command.  I'm failing to grasp the advantage of referencing format file with the BCP in (import) or BCP out (export) options.  With an import, either you have a correctly formatted import file and BCP command or you don't.  Right?  With an export file, your export is going to be the same whether you reference the format file or not.  Right?  Clearly, I'm missing the boat on the -f option, but I'm not sure how.  

I've been reading the following article: http://msdn.microsoft.com/en-us/library/ms191516.aspxStart Free Trial
 
Keywords: Understanding BCP and Format Files
 
Loading Advertisement...
 
[+][-]07.22.2008 at 12:20PM PDT, ID: 22062694

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL Server, SQL Server 2005
Tags: Microsoft, SQL Server 2005
Sign Up Now!
Solution Provided By: EugeneZ
Participating Experts: 2
Solution Grade: A
 
 
[+][-]07.22.2008 at 12:57PM PDT, ID: 22063024

Assisted solutions are selected by the member who asked the question as a comment that contributed to their question's solution.

Start your 7-day free trial to view this Assisted Solution or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628