August 25, 2010 at 1:08 pm
Hi ,
i have ssis 2005 and 2008 and there are some files in ssis 2005 that are not upgraded,but i unfortunately opened ssis 2008 and opened the solution from source control in ssis 2008 ,it gave me an option to upgrade i clicked it ,now i was unable to open the file in ssis 2005 and getting this message :
file was created by a newer version and cannot be opened.
Somebody please help me ...
August 25, 2010 at 2:23 pm
Can you restore from backup?
August 25, 2010 at 2:39 pm
You can't downgrade anything in SQL server (databases versions, service packs, SSIS packages).
Your only option is restoring from backup, as far as I know.
August 25, 2010 at 2:48 pm
I know how to restore sql database but ssis, i have no clue from where i should restore...
Any help?
August 25, 2010 at 2:53 pm
Where is the package stored? File system, or in the database?
If it is stored in the database, you'll need the msdb..sysdtspackages90 table I believe..I have never had to restore one so I can't verify, but I've done similar things with DTS packages in the past. Basically just delete the row for your upgraded/corrupted package (careful to do the right one), copy the row from the backup to the prod table, and that might be all you need.
August 25, 2010 at 2:56 pm
all the packages are stored in a file and then to source control.
August 25, 2010 at 2:58 pm
Do you have file system backups? If so, then just grab the .dtsx file from there and replace the corrupt one.
August 25, 2010 at 3:19 pm
srilu_bannu (8/25/2010)
all the packages are stored in a file and then to source control.
Then grab an earlier version from source control.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2010 at 3:44 pm
do you mean just get latest version from source control to the folder i am opening.........
August 25, 2010 at 6:56 pm
How to grab earlier version from source control
August 26, 2010 at 2:11 am
srilu_bannu (8/25/2010)
How to grab earlier version from source control
Read through the documentation for whatever source control system you're using. It's going to be different for different source control apps.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply