September 22, 2009 at 5:47 am
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
September 22, 2009 at 5:55 am
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
September 22, 2009 at 7:58 am
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