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.