Post reply

Transform Data Task Issue: Writing to Excel

  • 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 4 posts - 1 through 5 (of 5 total)

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