Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hirani_prashant
Yak Posting Veteran
93 Posts |
 Posted - 2008-05-10 : 03:36:46
|
| Hello All,I have created a job to execute a SSIS package located in the SSIS Package Store. When starting the job I receive an error. The history log reports:MessageExecuted as user: NT AUTHORITY\NETWORK SERVICE. 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.This is the command line:/SQL "\SwapSwire" /SERVER INDIADEVSRV /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING EWhat am I doing wrong? Can any one help me?ThanksPrashant |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-10 : 12:20:58
|
| What does the package do? Needs access excel? Where is excel file? |
 |
|
|
hirani_prashant
Yak Posting Veteran
93 Posts |
Posted - 2008-05-12 : 01:17:27
|
| Hello,Thanks for ReplyPackage is for importing data from excel file to Database.Excel file is located on my local system and package is on at Remote Location.Thanks Prashant |
|
|
|
hirani_prashant
Yak Posting Veteran
93 Posts |
Posted - 2008-05-15 : 08:22:31
|
| I tried my best bt can't find any solution.....Can any one please help me?ThanksPrashant |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-15 : 22:49:47
|
| You have to run sql agent with domain account that has permission to read file from your machine. |
|
|
|
|
|
|
SSIS Help