×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

DTS can copy table but not import records

DTS can copy table but not import records

DTS can copy table but not import records

(OP)

SQL 2000
Data Source: Excel 2000
(the excel file is created by a Crystal reports XI export)

This started with the "DTS runs manually but not when scheduled issue".  I read the FAQ and logged in as Admin and started to recreate the DTS

Now, I can create a DTS that creates a table from this Excel data, but if I try to create a DTS from that same file that will append records to the table it fails.  

this is what the package log says:


Step Error Source: Microsoft JET Database Engine
Step Error Description:The Microsoft Jet database engine cannot open the file ''.  It is already opened exclusively by another user, or you need permission to view its data.
Step Error code: 80004005
Step Error Help File:
Step Error Help Context ID:5003051

I do not know how the file could be open, I'm the only one who has permissions to it (me and the admin account) and no other program is currently using it.  

Where should I look next?  

Thank you for your help

VE

RE: DTS can copy table but not import records

(OP)
OK, I was having it run now and schedule at the same time when I was creating it.  When I tried to execute it once it was there it ran fine.  

AND it runs as part of a job now (thanks to the FAQ mentioned before.)

big smile

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close