Bulk copy to publication

Hello

I need to copy from excel table to SQL 2005 publication (many record > 1000)

How can i do this. Bulk copy? or ...

I have experience problem with bulk copy so how can i manange it for my own needs.

right click on the database you wish to import data to. Select Tasks, and Import Data, next, and for your data source, select Excel, browse to find your Excel spread sheet, click next, next, next, next, and Finish.

Bulk Copy Failed During Snapshot

I'm trying to start a new publication. When the snapshot agent runs, it stops on a table with the error "Bulk Copy Failed". If I remove the table from the publication, it just moves the error to the next table it tries to copy. What could cause a bulk copy to fail during a snapshot?

Hello,

In order for any of us to provide further assistence, we will need:

1) The version of SQL Server that you are using

2) Additional information regarding the nature of the error. You can probably find this through the error details pane in the UI or you can select it directly from the MSrepl_errors table in the distribution database.

-Raymond

|||

Sorry about the lack of info. I've been working on this off and on for 2 months and have gone brain-dead trying to figure it out.

Version:

SQl Server 2000

on Windows Server 2003

Error message:

The process could not bulk copy out of table '[dbo].[xxxxx]'.

Error details:

I/O error while writing BCP data-file
(Source: ODBC SQL Server Driver (ODBC); Error number: 0)

Thank you

(edited to correct versions)

|||

I am guessing this really is SQL2000 as the snapshot agent is using ODBC for performing the BCP operation. (There is no SQL2003)

The error "I/O error while writing BCP data-file" is typically caused by the lack of disk space on the snapshot drive. It may be a good idea to check if you have sufficient disk space on the snapshot drive.

Hope that helps,

-Raymond