|
|
Posted by Erland Sommarskog on 08/09/06 21:54
Ted (r.ted.byers@rogers.com) writes:
> Actually, I have been experimenting with BULK INSERT, bcp, and the
> import wizard simultaneously. I find some inconsistency in how they
> work. With bulk insert, it seems I can tell it to preserve my nulls,
> and I haven't found out how to do that with the wizard (which is
> accessable in SQL Server Management Studio by selecting the database
> and then, from the popup menu selecting either import data or export
> data).
I tried to use the wizard and import a file which did not have all values
for an int column, but I got the same error as you. Overall, the wizard
strained my patience, so I gave up after a while. It's certainly more
efficient with format files.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|