How come when i compile the package and try and run the package outside of the Developement enviroment(Visual studio) it complains about all my ssis scrip tasks. It brings up an error saying, it can not run under this edition of Integration services. It requires a higher level.
Is there another type of ssis that i do not know about, can you supply me a URL to help solve this problem
Thanks
Well, what version of SSIS are you using outside of the Development environment? And have you installed SSIS there?|||Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00
This is the version, it is the version that comes standard with the SQL 2005 server
|||Are you using Fuzzy Lookups, Fuzzy Grouping, or the Text mining tasks? These are only available in the Enterprise Edition of SSIS.|||And you still have to install the SSIS client software. Even though it comes with SQL Server, there is still a client part that needs to be installed.|||Yes there is fuzzy logic.
I do not know what has been installed,
can you tell me how to find out weather the client software has been installed
|||If you have not installed SSIS correctly, then any task or component can produce an error "product level is insufficient..."
http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx
The Fuzzy Tasks however are examples of those that really mean it, you need Enterprise Edition (or Developer).
To check which edition of SSIS you ahve installed look in the registry-
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\90\DTS\Setup
Look at the Values Edition and/or EditionType values.
No comments:
Post a Comment