May 5, 2009 at 2:01 pm
I created a SSIS package in SQL 2008. I then scheduled it in SSMS as a job.
When i run it i get the following error "The version number in the package is not valid. The version number cannot be greater than current version number".
I did some research on this error and the DTEXE that's being used is the pervious version, since i have both SQL 2005 and 2008 on the same server. From what i found online i have to hard code the path of the SQL 2008 DTEXE when calling my SSIS package.
I have no idea how to do this and I'm looking for some direction on how this is done, or if their is any other way to get my SSIS package to run as a job from SSMS all is SQL 2008
Thank you
May 5, 2009 at 2:23 pm
In the job agent is your step type ssis?
May 6, 2009 at 11:22 am
Yes it is. The type is SQL Server Integration Services Package.
May 6, 2009 at 12:41 pm
just checking...thats a crappy issue.
Is it really critical to have 05 on the server??
if not then there is 1 obvious solution.
or you may try running dtexec command line util.
There will be a different exeutable relative to each sql server instance..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply