June 9, 2009 at 6:04 am
I noticed my SSIS2005 packages are failing with a message "higher level edition required" when I wanted to run a package.
The package contains a simple export of data to msaccess - no state of the art conversions (except string to unicode).
The package has been developed on BIDS 2005 SP3.
The server it was testing it on was still on SP2.
So I copied the dtsx to a server with sp3 on it.
Still the execution gives me this Higher level edition required error.
X:\>"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /FILE "C:\SSIS_Deployment\ExportDB_2_EUC_MDB.dtsx
" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING E
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 14:20:23
Error: 2009-06-09 14:20:32.13
Code: 0xC00470FE
Source: Load Top Level - Locations DTS.Pipeline
Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Data Conversion 7" (733).
End Error
DTExec: The package execution returned DTSER_FAILURE (1).
Started: 14:20:23
Finished: 14:20:32
Elapsed: 9 seconds.
What can I do to get this package in a state that I can schedule its execution ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
June 9, 2009 at 7:11 am
You should install SSIS server components to schedule the package!!
Apparently adding SQL2008 (devedtn + bids) messed up my settings.
I'll have to figure out a workaround.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply