RE: Importing Fixed Width Files with Multiple Occurrences

Here are the only switches I see in the bcp utility:

C:\>bcp
usage: bcp {dbtable | query} {in | out | queryout | format} datafile
[-m maxerrors] [-f formatfile] [-e errfile]
[-F firstrow] [-L lastrow] [-b batchsize]
[-n native type] [-c character type] [-w wide character type]
[-N keep non-text native] [-V file format version] [-q quoted identifier]
[-C code page specifier] [-t field terminator] [-r row terminator]
[-i inputfile] [-o outfile] [-a packetsize]
[-S server name] [-U username] [-P password]
[-T trusted connection] [-v version] [-R regional enable]
[-k keep null values] [-E keep identity values]
[-h "load hints"]

There is not a -x switch.

Thanks,
Jason

"Jason" wrote:

Hello,

I am trying to create a format file using the BCP utility. However, I do
not have the -x switch available in my bcp utility. I do have SQL Server
2005 installed. How can I get the newer version of the BCP utility that has
the -x switch for creating an XML format file?

Thanks,

Jason


""Charles Wang [MSFT]"" wrote:

Hi Jason,
I am not sure of your meaning of creating 265 fields with a length of 8
characters in the connection object UI. You can define columns and columns
length by clicking the ruler to make markers and dragging the markers to
set each column length. You can find it at Columns pane in your Flat File
Connection Manager Editor. The operation is convenient per my experiences.

Please feel free to let me know if you have any other questions or
concerns. Have a nice day!


Best regards,
Charles Wang
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================




.

Relevant Pages

  • RE: Importing Fixed Width Files with Multiple Occurrences
    ... I am trying to create a format file using the BCP utility. ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.dts)
  • Re: 2.6.23-rc8-mm2
    ... duplicate filename 'switch' can not be created ... 2000-2006 Netfilter Core Team ... # IPVS transport protocol load balancing support ... # Device Drivers ...
    (Linux-Kernel)
  • RE: Step by Step skips large chunks of code
    ... In project properties page, switch to tab, and check if the ... has been correctly complied into assembly code. ... Microsoft Online Community Support ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.vsnet.debugging)
  • Re: problems with fast user switching
    ... Windows XP Displays the Logon Dialog Box on a Black Screen ... For a complete list of Microsoft Product Support ... try to switch between users I get the Unlock Computer Dialog ...
    (microsoft.public.windowsxp.general)
  • Re: OCD programmers and backwards compatibility :-).
    ... /dev/sdx as part of the switch to libsata. ... the foobar package play nice with the rest of the release. ... and user-hostile changes for arbitrary reasons (and *all* filename changes are ... arbitrary) obviously don't support any existing large integrated systems. ...
    (Fedora)