Product Level is Insufficient error

  • No luck searching Google or these forums, my apologies if I've missed the answer.

    I'm running SQL2K5 Workgroup on this particular server. I have a small SSIS package that runs a flat file import, runs it through a derived column transformation, and dumps the result into a SQL table. It runs perfectly from within BIDS, but fails when I run it as a job within SQL Server, informing me the product level is insufficient for component derived column.

    SSIS is installed on the server. I even removed Integration Services, reinstalled it, and re-applied SP3. It's on there. However, I still get this error and it's never showing up as an installed service. Will Workgroup simply not do derived columns? I know there are certain features that only work within Enterprise/Developer editions, but I was not aware that this was one of them. Or is there something else I'm not seeing?

  • jason-602680 (9/14/2010)


    No luck searching Google or these forums, my apologies if I've missed the answer.

    I'm running SQL2K5 Workgroup on this particular server. I have a small SSIS package that runs a flat file import, runs it through a derived column transformation, and dumps the result into a SQL table. It runs perfectly from within BIDS, but fails when I run it as a job within SQL Server, informing me the product level is insufficient for component derived column.

    SSIS is installed on the server. I even removed Integration Services, reinstalled it, and re-applied SP3. It's on there. However, I still get this error and it's never showing up as an installed service. Will Workgroup simply not do derived columns? I know there are certain features that only work within Enterprise/Developer editions, but I was not aware that this was one of them. Or is there something else I'm not seeing?

    If you "know there are certain features that only work within Enterprise/Developer editions" then why don't you take the time to look up what those are?

    http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • I have, and while derived columns isn't specifically listed, I didn't know if they were included in some other category.

  • jason-602680 (9/14/2010)


    I have, and while derived columns isn't specifically listed, I didn't know if they were included in some other category.

    Forget about derived columns for now. What does it say about SSIS (SQL Server Integration Services)?



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • And therein lies the trouble. I realize it says IS with basic transforms are not supported in Workgroup, but I don't know what that means as far as what I'm trying to do. SQL development isn't even on the list of things I typically do, and even DBA is pretty near the bottom so I'm not quite sure what it is I'm looking at.

  • jason-602680 (9/14/2010)


    And therein lies the trouble. I realize it says IS with basic transforms are not supported in Workgroup, but I don't know what that means as far as what I'm trying to do. SQL development isn't even on the list of things I typically do, and even DBA is pretty near the bottom so I'm not quite sure what it is I'm looking at.

    Take a look at this lnk instead: http://msdn.microsoft.com/en-us/library/ms143761(SQL.90).aspx

    Towards the bottom of the page you'll see that there is no support for any SSIS transforms in the Workgroup edition.



    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • That's the answer I was looking for. I don't know why I didn't find it, but thanks for that.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply