admin posted on October 28, 2009 14:54

Both versions of BIDS installed gives an error. 

 

The new SSIS gig fully underway, and I happened upon an error that I'd never seen before, so wanted to write it down.  You might get the following when developing SSIS and calling .dtsx files from DTEXEC locally: 

Description: The version number in the package is not valid. The version number cannot be greater than current version number.

 

This is due to the fact that you have installed both versions of BIDS installed locally, and you must specify the .exe that you want to be fired when calling DTEXEC because there are two versions on your system.  Either that or simply rename or remove the older version  (if you are not going to use it again).  

 

 Simply specify the entire path of the .exe at the command line and it should work for you: "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" like so:

 

 

Happy SSIS'ing!

Lee

 

----------------------------------

But I saw the boogeyman! I saw him!  


Posted in: SQL Server 2008/R2 , SSIS  Tags:

Comments

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading




by Lee Everest, M.S.

Search


Ads

Calendar

«  July 2010  »
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2010 Lee Everest's SQL Server, etc. weblog