Solved

Bulk Insert Failed

Posted on 2002-06-13
1
222 Views
Last Modified: 2011-10-03
I am recieving an error message through and application that :

Bulk load failed
Can't connect to server GANT12, database Millennium, user Millennium, COM error 0x80040000

Merge failed
0
Comment
Question by:caryma
1 Comment
 
LVL 35

Accepted Solution

by:
David Todd earned 50 total points
Comment Utility
Hi,

Silly question, but is the bulkcopy option set on this database?

ie
sp_dboption 'pubs', 'select into/bulkcopy'

Regards
  David
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now