I installed SQL Server 2005 Standard Edition on my XP sp2 workstation, developed an SSIS package, which has run for a week on my workstation.
I installed SQL Server 2005 Standard Edition on a Win2003 sp1 server, created the dtsx and install manifest on my workstation, and installed it on the server.
If I run the package on my workstation, pointed to the server database it runs fine.
If I run the dtsx on the server, it fails with the error:
The product level is insufficient for component "Fuzzy Lookup on Name" (83)
Yes, I have SSIS installed on both machines, I have verified that I have the SSIS service on the server.
Any Ideas?
Thanks!
BobP
Bob,Fuzzy Lookup/Fuzzy Grouping components are part of the Advanced Transformations that are only available in the Enterprise Edition of SQL.
Per MS all transformations/features are available in the BIDS when you are developing. So you really need to becareful about what features you use in your packages.
Larry Poep|||
Thanks
BobP
No comments:
Post a Comment