Post reply

DTS Error

  • December 12, 2001 at 8:39 am

    #104696

    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

  • December 12, 2001 at 8:57 am

    #421040

    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

  • December 12, 2001 at 10:17 am

    #421047

    This error looks like you do not have change rights to the file. Ave you checked that?

    There might be a 255 char limit.

    Steve Jones

    steve@dkranch.net

  • December 12, 2001 at 11:27 am

    #421053

    Belive me,I check that a couple of times and there is no problem.The weird thing is if I have less then 30 character in the excels connections filename,than it works very well.

    Maybe there is a limitation there !?!

    Any suggestions?

    Sica

  • December 12, 2001 at 1:12 pm

    #421057

    Shouldn't be. What is the filename and path? Any spaces.

    Steve Jones

    steve@dkranch.net

  • December 13, 2001 at 1:08 am

    #421071

    Hi Steve,

    Thanks for your answer.

    There is no space or anything else...

    The connections file name is 60 not 30 as I wrote before.Here comes an exemple:

    SELECT LEN('\\STR_SQLMAR01\FOC\OUT\ONLINE\WITHD_FOC_STS_focadm_marius_test1')

    This is 63 long but if I reduce it to 60 it works:

    SELECT LEN('\\STR_SQLMAR01\FOC\OUT\ONLINE\WITHD_FOC_STS_focadm_marius_te')

    Thanks,

    Sica

    Edited by - sica on 12/13/2001 01:09:06 AM

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply