Post reply

DTS Permission denied

  • September 3, 2004 at 8:30 am

    #161425

    I have a problem in running a DTS. My DTS package has 4 different steps which is at first step I

    have a ActiveXScript running. What it does it is deletes an excel file (testfile.xls) in the server.

    The following steps transforms a data from a DB table and creates an excel file as output.

    Then in Step 4 I have to rename this Excel file also in the server, (using a ActiveXScript and the MOVEFILE sentence) here I got the message

    "Permission denied".

    But when I run it seperatly it runs successfully. 

    I am using the Scripting.FileSystemObject, Excel 2000 and SQL Server 2000.

    Could you give me solution for that.

    Thanks

     

    Cesar Altamirano.

  • September 6, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • September 6, 2004 at 9:47 am

    #521883

    Hi, the only time i have come across this kind of message was when i ran a DTS package as part of a SQL Agent Job. the package included extracting data from a spreadsheet and populating an SQL table. the package worked fine if i ran it from the designer, it would also run fine if  i selected it from the list of packages and chose execute from the right-click menu. however when running it as a job within SQL Agent it would return an error similar to the one you encountered.

    i discovered that the log-on used by SQL Agent did not have the right permissions to access the spreadsheet. consequently the request to open the file got bounced.

    i don't know if this is relevant as i don't think you mention where you are executing the package from. just hope this helps.

    regards

     

    duncan

     

    All the best,

    Duncan

Viewing 3 posts - 1 through 2 (of 2 total)

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