Product Level Is Insufficient Error

Configuration: Windows XP Pro with SQL 2005 Workgroup Sp2

Hi, we have a package that runs fine in BI Studio but fails with the following error when executing it using DTExec.


Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Derived Column" (10660).

The package imports a CSV into a table mapping some columns. The MSDN article at http://msdn2.microsoft.com/en-us/library/ms143761.aspx describes features supported by different versions.

The article says OLE DB source/destination adapters are supported in WG edition but a couple of lines later seems to imply that all source/destination adapters are not supported in WG.

Could you clarify whether stuff like import of a csv into a table with some column mappings should work in WG edition? Also if we have a legacy SQL 2K package doing the same thing, will that work in WG edition? Thx.





Features/Integration Services Enhancements
EE (32-bit) DE (32-bit) EE (64-bit) DE (64-bit)
SE (32-bit)
WG (32-bit)
SSE (32-bit) SSEA (32-bit)
SE (64-bit)



SQL Server Import and Export Wizard and supporting connections, source and destination adapters, and tasks


Yes


Yes


Yes


No


Yes



Execute SQL Task


Yes


Yes


Yes


No


Yes



OLE DB Source and Destination Adapters


Yes


Yes


Yes


No


Yes



SSIS command prompt tools


Yes


Yes


Yes


No


Yes



SSIS Package Designer


Yes


Yes


Yes


No


Yes



Legacy support for DTS packages


Yes


Yes


Yes


Yes


Yes



SSIS Service


Yes


Yes


No


No


Yes



All other source and destination adapters, tasks, and transformations, except for those listed below


Yes


Yes


No


No


Yes