September 14, 2010 at 11:01 am
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?
September 14, 2010 at 1:15 pm
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
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]
September 14, 2010 at 1:19 pm
I have, and while derived columns isn't specifically listed, I didn't know if they were included in some other category.
September 14, 2010 at 1:21 pm
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)?
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]
September 14, 2010 at 1:26 pm
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.
September 14, 2010 at 1:36 pm
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.
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]
September 14, 2010 at 1:44 pm
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