| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 362.1 | Proper address... | XSTACY::16.43.176.7::jlundon | Real e-address -> [email protected] | Tue Apr 22 1997 05:55 | 6 |
| My proper return address is [email protected] .
I don't seem to be able to get NetNotes to accept an "@"
in Options/Setup/Username :-(.
James.
|
| 362.2 | | CSC32::HOEPNER | A closed mouth gathers no feet | Tue Apr 22 1997 15:14 | 3 |
|
What is your exact bcp statement?
|
| 362.3 | More information on BCP problem | XSTACY::16.43.176.7::jlundon | Real e-address -> [email protected] | Wed Apr 23 1997 02:42 | 51 |
| The BCP command is bog standard in the sense that I have no problems
using either /n or /c to extract the data and the fact that the command
line itself is fairly straightforward e.g.
C:\> BCP DB..Table out .\table.bcp /n /S XXXXXX /U xx /P
Starting copy...
X rows copied
Network packet size (bytes): XXXX
Clock Time (ms.): total = XX Avg = XX (XX.XX rows per sec.)
or
C:\> BCP DB..Table out .\table.bcp /c /S XXXXXX /U xx /P
Starting copy...
X rows copied
Network packet size (bytes): XXXX
Clock Time (ms.): total = XX Avg = XX (XX.XX rows per sec.)
The problems only begin when I try an put the extracted file back into
the empty database table:
C:\> BCP DB..Table in .\Table.bcp /n /S XXXXXX /U xx /P
Msg 529, Level 16, State 1:
Server 'XXXXXX', Line 1:
Explicit conversion from datatype 'int' to 'datetime' is currently
unimplemented.
or
C:\> BCP DB..Table in .\Table.bcp /c /S XXXXXX /U xx /P
Msg 529, Level 16, State 1:
Server 'XXXXXX', Line 1:
Explicit conversion from datatype 'int' to 'datetime' is currently
unimplemented.
I then dabbled a little with FMT files, with the same errors occurring
as before - the data was successfully extracted but could not be put
back into the database. Is there a mechanism available that will allow
the data be stored in the BCP file via a FMT file that will allow for
its later successful insertion?
(I was unsuccessful finding a similar problem in either Dejanews or
COMET V4.2, so either the problem is extremely common or extremely rare
- hopefully the former for my sake.)
James.
|
| 362.4 | No defaults for the datetime columns | XSTACY::16.43.176.7::jlundon | Real e-address -> [email protected] | Thu Apr 24 1997 09:43 | 10 |
| It looks like the problem concerned the fact that I hadn't set
up any default values for the datetime column. This resulted
in invalid data getting written to the BCP file and thereafter
problems getting it back into the database. When getdate() was set
as a default in the column in question and BCP re-run, all worked
OK.
Thanks,
James.
|
| 362.5 | | GUIDUK::HEALY | Alan Healy @ZSO | Thu Apr 24 1997 16:10 | 12 |
| I agree that bcp stands out as the most difficult tool in the SQL
Server toolbox. It's a holdover from the old Sybase days when
character cell interfaces were standard.
For what it's worth, I haven't seen a database system that has a sexy
load utility - that seems to be low priority (after all, it never gets
demo'd) - I worked quite a bit with Rdb's RMU/LOAD and it was the same
story - poorly documented and difficult to work with. There are 3rd
party load utilities that probably are a little easier to use.
Al
|
| 362.6 | BCP is fine when You get it to work... | STKHLM::KNORN | I'm still here | Tue May 06 1997 02:03 | 6 |
|
I got tired of getting all these kind of nonsense messages and
accvios when loading data with bcp, so I created my own loading routine
in order to get more control of the process.
Stefan
|