SQL Server Agent Job Error

  • HI,

    i am in a process of creating a job to export data from database to excel sheet using ssis package... but when i am trying to run the job i am getting the following error...

    Error Message:

    Executed as user: CAN\u_sql. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Argument "Excel" for option "connection" is not valid. The command line parameters are invalid. The step failed.

    can anyone help me with the above error..

    Thanks

  • p.ramchander (9/22/2009)


    HI,

    i am in a process of creating a job to export data from database to excel sheet using ssis package... but when i am trying to run the job i am getting the following error...

    Error Message:

    Executed as user: CAN\u_sql. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Argument "Excel" for option "connection" is not valid. The command line parameters are invalid. The step failed.

    can anyone help me with the above error..

    Thanks

    attach your dtsx package please

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

  • Hi Henrico

    Thank you for your reply.

    i have find the solution for the problem.

    Rather than using "SQL Agent Service Account", i created a new proxy and used the proxy instead, it worked like a charm...

    Thanks

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

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