Hi All, I created one package.I executed that package through BIDS its working fine.I created one configfile.I am trying to execute the same package but i am getting the error like below The product level is insufficient for component "rowcount"(16).Please help me in this issue. Thanks CMK..

What edition and version of SQL Server do you have on the server? Can we assume you have Developer edition on your workstation? What resources is your package hitting when it runs? Databases on the server? Does your package have a RowCount transform in the Data Flow? Have you tried disabling the Configurations and running it on the server? Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Thanks for your response Todd. My pacakge have rowcount transformation. With out config file my package executed successfully.I am wating for DBA response regarding the edition of sqlserver in my dev server. Thanks CMK

I can't imaging the Row Count would make a difference. I have Standard edition on my servers and use Row Count with no issue. Try this: Create two identical (simple) packages, but put a Row Count in one. See if both execute. (Don't use and COnfigs at this point). if they BOTh execute OK, add the config to both and see what happens. This is basic 'swap-nostics' debugging technique.Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

Sure I'll do it. Thanks CMK...

What did you enable in your config file? ie. what options were checked? Did you change anything manually after the config file was generated?Please 'Mark as Answer' if found helpful - Chris@tier-1-support

Have you verified that the SSIS components are actually installed on the server? The only time I have seen this error is when someone is running the package outside of BIDS (using SQL Agent or DTEXEC) on a box that doesn't have the SSIS service installed properly. If it runs successfully outside of BIDS with no configuration, then SSIS is probably installed properly. But I'd like to know more about how you are executing the package when you get this error.John Welch | www.varigence.com | www.agilebi.com | ssisUnit.codeplex.com

TODD...i created 2 simple packages one pacakge have rowcount transformation ,one more package doesn't have row count transformation.for both packages i created one config file, which pacakge doesn't have rowcount transformation that package executed sucessfully through config file.the second package doesn't execute through config file but it executed sucessfully through bids.what's my problem? In that server i need update any service pack ? Thanks CMK...

I can't see how a configuration file could cause issues with a rowcount. What is that config file doing? did you validate that SSIS is installed in the server? I am not sure what you mean by "package doesn't execute through config file" are we talking about an XML package configuration file?Help Others! Don't forget to mark your thread as answered