July 8, 2011 at 10:12 am
My package runs fine locally but when I run it at command line, I get this error:
"The task "Download files" cannot run on this edition of SSIS. It requires a higher level edition."
The task is an "Execute Process Task" which calls a bath file. My question is how come it works while running via Visual Studio locally but not via command line? Btw, I have VS 2005, SSIS version 9.00.1399.0
July 8, 2011 at 10:15 am
What is the command you are using at the command line?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 8, 2011 at 10:17 am
dtexec /f "H:\DEVL\SSIS\ADPR Import\ADPR People Import.dtsx"
July 8, 2011 at 10:17 am
BIDS will let you do development for any edition of SQL, even ones that you don't own. I would surmise that DTExec evaluates the edition and won't let you run a package that contains components above what is on the machine..
Just a thought.
CEWII
July 8, 2011 at 10:57 am
so do I need to install VS 2008?
July 8, 2011 at 11:47 am
No, that would only let you run the package from VS by hand, so that doesn't solve your problem at all.
And BIDS doesn't really use DTExec to execute the package anyway.
you might look at this thread: http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/86e4071d-e018-4618-91f1-08016bbc6391/[/url]
but this was my search on google: "execute process task" "higher level edition"
CEWII
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply