Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2000 DTS
This is the forum to discuss the Wrox book Professional SQL Server 2000 DTS (Data Transformation Services) by Mark Chaffin, Brian Knight, Todd Robinson; ISBN: 9780764543685
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2000 DTS section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old November 17th, 2008, 07:12 AM
Authorized User
 
Join Date: Dec 2006
Location: chennai, tn, India.
Posts: 62
Thanks: 0
Thanked 0 Times in 0 Posts
Default DTS - Bulk Insert Error

Hi,

I'm importing the file data into sql server using DTS - Bulk Insert. While running the package the Bulk Insert task failed for the last 3 times, prior to that it was running absolutely fine. Please find the below error.
------------------------------------------------------------------
DTSRun OnError: DTSStep_DTSBulkInsertTask_1, Error = -2147217900 (80040E14)
Error string: Could not bulk insert because file 'C:\test.txt' could not be opened.
Operating system error code 32(The process cannot access the file because it is being used by another process.).
Error source: Microsoft OLE DB Provider for SQL Server
------------------------------------------------------------------
In order to resolve this issue, i tried to run the package again by pointing the source file path differently and manually copied the source file to that location (running with the same location failed again). I'm wondering the issue did not escalated during previous run.

Your suggestion is highly appreciated on this.

Thanks,
Chandra
__________________
Thanks,
Chandra
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Bulk Insert TSQL in DTS – Rows Affected Count sjm SQL Server DTS 2 May 30th, 2008 11:40 AM
bulk insert hymavathy_kr VB Databases Basics 1 May 17th, 2007 07:47 AM
Error Handling in Bulk Insert starnet SQL Server 2000 0 October 12th, 2006 03:27 AM
Bulk Insert luma SQL Server DTS 1 July 13th, 2005 01:48 AM
bulk insert error - help needed!! fgeorge SQL Server 2000 2 May 25th, 2004 04:38 PM



All times are GMT -4. The time now is 07:35 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.