 | |
Importing Fixed Width Files with Multiple Occurrences
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#71
 
| |||
| |||
|
RE: Importing Fixed Width Files with Multiple Occurrences -
04-23-2008
, 09:08 AM
|
Hi Jason, I have checked the bcp utility at my computer. It does include -x option. The path is %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\bcp.exe. When I typed "bcp /?" from command line, I got the following output: 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"] [-x generate xml format file] The -x option should be supported if you installed SQL Server 2005 on your instance. You may run Process Monitor to check if you executed an older version bcp utility. You can download Process Monitor at this link: http://www.microsoft.com/technet/sys...essmonitor.msp x 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 (AT) microsoft (DOT) com. ================================================== ======= This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== ======= |
#72
| |||
| |||
|
|
Hi Jason, I have checked the bcp utility at my computer. It does include -x option. The path is %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\bcp.exe. When I typed "bcp /?" from command line, I got the following output: 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"] [-x generate xml format file] The -x option should be supported if you installed SQL Server 2005 on your instance. You may run Process Monitor to check if you executed an older version bcp utility. You can download Process Monitor at this link: http://www.microsoft.com/technet/sys...essmonitor.msp x 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 (AT) microsoft (DOT) com. ================================================== ======= This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== ======= |
#73
| |||
| |||
|
|
Hi Jason, I have checked the bcp utility at my computer. It does include -x option. The path is %ProgramFiles%\Microsoft SQL Server\90\Tools\Binn\bcp.exe. When I typed "bcp /?" from command line, I got the following output: 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"] [-x generate xml format file] The -x option should be supported if you installed SQL Server 2005 on your instance. You may run Process Monitor to check if you executed an older version bcp utility. You can download Process Monitor at this link: http://www.microsoft.com/technet/sys...essmonitor.msp x 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 (AT) microsoft (DOT) com. ================================================== ======= This posting is provided "AS IS" with no warranties, and confers no rights. ================================================== ======= |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.