I build a SSIS package, which contains a fuzzy lookup process on a SQL Server 2005, SP2. It runs fine by itself. It compares names found in a SQL Server 2000 database, to names found in a SQL Server 2005 database.
The problem arises when I schedule this package to run via a job in SSMS. It keeps giving me the error of "SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Fuzzy Lookup" (43)."
The SQL Server 2005 box that this job and SSIS package is on, is standard edition.
Why does it run fine in SSIS, but not as a job in SSMS, when everything is on one box ?