Running eval. edition of Sql Server Standard 2005. "Insufficient product level" error is thrown during validation phase of an OleDBCommand data flow task. This task type is not licensed in Sql Server 2005 standard The component runs a very simple sql update statement against a one row table in Sql Server 2005.
If it works from BIDS, should it not work from dtexec.exe on the same box
Does dtexec run under the security context of the logged in user
Thanks,
Ken
Package runs fine from BIDS, but same box running from dtexec gives "insufficient product level" error
kwarnke
Without full SSIS installation, you'll get "Insufficient product level" error when running most packages in DTEXEC.
Richard Waymire - MSFT
tigger30
Hi Jamie,
I wasn't clear, sorry. Dtexec is installed on the box. in fact, it is the dtexec environment that reports the error when the package is validating (it opens a cmd window and shows the validation output to the console). I am running everything on one box-complete install of Sql Server 2005, plus complete install of SSIS.
The package runs fine under bids, but when I run it from dtexec the validation reports one error "The product level is insufficient for component x"...
Here is the error report generated by dtexec:
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.1399.06 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 4:50:46 PM
Progress: 2006-03-16 16:50:48.71
Source: GetDateRangeFromUser
Validating: 0% complete
End Progress
Progress: 2006-03-16 16:50:48.81
Source: GetDateRangeFromUser
Validating: 50% complete
End Progress
Progress: 2006-03-16 16:50:49.37
Source: GetDateRangeFromUser
Validating: 100% complete
End Progress
Progress: 2006-03-16 16:50:49.39
Source: Update TblParameters with Earliest and Latest Post Dates from Source
Validating: 0% complete
End Progress
Progress: 2006-03-16 16:50:49.39
Source: Update TblParameters with Earliest and Latest Post Dates from Source
Validating: 50% complete
End Progress
Progress: 2006-03-16 16:50:49.40
Source: Update TblParameters with Earliest and Latest Post Dates from Source
Validating: 100% complete
End Progress
Progress: 2006-03-16 16:50:49.40
Source: Update TblParameters with Earliest and Latest Post Dates from Source
Validating: 0% complete
End Progress
Progress: 2006-03-16 16:50:49.42
Source: Update TblParameters with Earliest and Latest Post Dates from Source
Validating: 50% complete
End Progress
Progress: 2006-03-16 16:50:49.42
Source: Update TblParameters with Earliest and Latest Post Dates from Source
Validating: 100% complete
End Progress
Error: 2006-03-16 16:50:49.43
Code: 0xC00470FE
Source: Update TblParameters with Earliest and Latest Post Dates from Source DTS.Pipeline
Description: The product level is insufficient for component "Update tblParameters" (499).
End Error
Warning: 2006-03-16 16:50:49.43
Code: 0x80019002
Source: Package
Description: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
End Warning
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 4:50:46 PM
Finished: 4:50:49 PM
Elapsed: 2.531 seconds
Jeff Guenthner
Ok guys, I'll try a re-install I guess. From what I can tell, everything was installed on the first try.
Thanks!
MayaMan
Not necassarily. You can run packages in BIDS if you have installed Workstation Tools.
You need to have installed Integration Services (i.e. off the CD) in order to use (actually, in order to install) dtexec.exe.
-Jamie