Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DTS Error

Author  Topic 

sica
Posting Yak Master

143 Posts

Posted - 2001-12-12 : 10:25:00
Hi sql-forum,
I get this error message when I tried to run a DTS-package.The package har only 2 step,one creates the table into an excel file and the other one is the data pumping.

Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:Unspecified error
(Microsoft JET Database Engine (80004005): Cannot update. Database or object is read-only.)
Step Error code: 80074005
Step Error Help File:sqldts.hlp
Step Error Help Context ID:1100

Sounds familiar ?

Thanks in advance!
Sica

sica
Posting Yak Master

143 Posts

Posted - 2001-12-12 : 10:44:32
I checked a bit closer and the problem is when I create the excel connection then I get the error message.Is there any limitation how long the excelfile name could be?

Sica

Go to Top of Page
   

- Advertisement -