Post reply

Upgraded everything to ssis 2008

  • August 25, 2010 at 1:08 pm

    #226213

    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

    #1211927

    Can you restore from backup?

  • August 25, 2010 at 2:39 pm

    #1211942

    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

    #1211955

    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

    #1211957

    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

    #1211958

    all the packages are stored in a file and then to source control.

  • August 25, 2010 at 2:58 pm

    #1211960

    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

    #1211966

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 25, 2010 at 3:44 pm

    #1211970

    do you mean just get latest version from source control to the folder i am opening.........

  • August 25, 2010 at 6:56 pm

    #1212014

    How to grab earlier version from source control

  • August 26, 2010 at 2:11 am

    #1212122

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply