SSIS Error When executing from command line

ssis

I have a small SSIS package which exports data to a excel file from SQL server 2008. The package works perfectly fine in our dev environment, when the package is moved to our another environment we receive the below error on execution from command line.
The package runs for a while and then gives the below error

Error: 2012-05-21 18:34:01.61
   Code: 0xC000F427
   Source: Create Summary From Detail SSIS.Pipeline
   Description: To run a SSIS package outside of Business Intelligence 
   Development Studio you must install Standard Edition of Integration Services 
   or higher.
End Error

Other SSIS packages which were exported to this environment before are working fine now. Only this package is throwing this error, what i meant to say is we are having the SSIS installed on this environment.

Can Some one please let me know what could be the possible reason for this?
Please let me know if you need more information.
Thank you

Best Answer

What version of SQL Server do you have installed on your computer? You need at least SQL Server 2005 Standard Edition. If you are running Workgroup Edition or SQL Server Express, you will have difficulties with advanced SSIS features (unless you are running through Visual Studio.)

See http://msdn.microsoft.com/en-us/library/cc645993.aspx#SSIS for a list of SSIS features not supported by SQL Server Workgroup.

Related Topic