Integration Services Advanced Transforms feature check
Hi, How I can check whether we are using "Integration Services Advanced Transforms" feature. We have SSIS service running and have SSIS packages to transfer data to another server. We are on SQL Server 2005 SP2 EE. Regards, Murtuja KhokharWith Regards, Khokhar Murtuja S Database Administrator
December 22nd, 2010 11:42pm

if you have any of these transforms, then you are using "advanced transforms": Data mining query transformation Data mining model training destination adapter Fuzzy Grouping transformation Fuzzy Lookup transformation Term Extraction transformation Term Lookup transformation Dimension processing destination adapter Partition processing destination adapter Note that when you work with SQL Server enterprise edition you have all of these transforms available and you can use them. in the Standard edition these features not available. http://www.microsoft.com/sqlserver/2005/en/us/compare-features.aspx#integration http://www.microsoft.com/sqlserver/2005/en/us/enterprise-compare-editions.aspx#bichttp://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
December 23rd, 2010 12:39am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics