Post reply

Transform Data Task Issue: Writing to Excel

  • October 29, 2003 at 11:59 am

    #107185

    I'm having trouble writing data from SQL to Excel using the Transform Data Task. I receive the following error:

    ========

    Step 'DTSStep_DTSDataPumpTask_2' failed

    Step Error Source: Microsoft Data Transformation Services (DTS) Package

    Step Error Description:Access is denied.

    (Microsoft Data Transformation Services (DTS) Package (80070005): Cannot open a log file of specified name. Access is denied.

    )

    ========

    What is odd is that in two steps prior to this the package I have 2 Execute SQL tasks against the Excel Connection that succeed. And also, the package works when run as a package manually and also works when run as a Scheduled Job on a Dev server, and the package works when run manually on the Test server, but it fails when trying to run as a scheduled job on the Test server.

    Any ideas?

  • October 29, 2003 at 3:29 pm

    #480200

    What are the differences in the setup of the SQLAgent between Dev and Test?

    Executing the package manually uses the credentials you used to access the server. It will also run the package from wherever you execute it. ie: if you use EM of your workstation to connect to the server and execute the package, it will execute on your workstation using your security credentials.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • October 30, 2003 at 9:03 am

    #480332

    Double check the options tab in the Transform task. If you have an exception file that is trying to be created, it might not be available to the SQL Agent.

    Steve Hughes

    Magenic Technologies

  • October 30, 2003 at 11:11 am

    #480347

    Do you have the Excel document open???

    JCL 🙂

  • October 30, 2003 at 11:26 am

    #480348

    I didn't change the exception file for the new environment...

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

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