Post reply

SSIS Deployment

  • July 1, 2011 at 8:40 am

    #243577

    Hello,

    I have SSIS package and it is in 2008.

    I am using sql server tool 2008 and I have server which we are using is 2005.

    I have problem with deployment.

    Error : The package installation wizard requires integration service to be installed by one of these edition : sql server 2008 :standard, enterprice, development and evaluation . To install integration service , Run sql server set up and select integration service.

    I don't understand these message exactly....

    I have sql server 2008 tool and i have created package in ssis 2008.

    but i don;t have sql server 2008 . i have sql server 2005.

    Can i know how to deploy package??

    Thanks

    L

  • July 1, 2011 at 9:14 am

    #1347094

    you wont be able to as the runtime for 2008 is different than 2005

    you will need to get hold of BIDS for 2005 and redesign the package and redeploy

    packages can go up versions, so create in bids 2005 will work on sql 2008, but you cannot downgrade eg bids 2008 on sql 2005

  • July 1, 2011 at 9:30 am

    #1347109

    Thanks for replying me.:-)

    So can i upgrade sql server 2005 to sql server 2008.

    I have 8-10 different Databases and they are used by others,

    I am using only one database ....can i migrate all databases..??

    How can i install sql server 2008 .... if i have sql server 2005 with different databases??

    IF i will install sql server 2008 then any condition like first uninstall sql server 2005 then install sql server 2008?????

    or if i have 2005 and i can aslo install 2008 with uninstalling sql server 2005 .????

    Thanks

    L

  • July 1, 2011 at 9:36 am

    #1347117

    you will need first to run the database upgrade wizard on the 2008 media to ensure that your databases can be upgraded.

    if they can then you can do an in place upgrade or a side by side upgrade.

    if they can not then you will need to fix the issues first before upgrading.

    you can have 2005 and 2008 on the same server but you will need to give the new instance a name eg SERVER\SQL2008

    i would backup the databases on 2005 and restore on 2008

    all this seems a bit excessive though for what you are trying to do, i would just get the 2005 media and install BIDS from this and use that for your SSIS packages.

    also are you licenced to use 2008? do you have software assurance with the licences your company purchased if so check that the SA hasn't expired? if you havn't then the only thing you can do is purchase new licences or ask Microsoft for an addon software assurance if they will offer it to you or stay on 2005.

  • July 1, 2011 at 10:52 am

    #1347186

    Thanks for your reply 🙂

    I am looking for solution ....So i have so many to thing to figure it out.....

    Anyways.....Thanks again,,,

    Thanks

    L

Viewing 5 posts - 1 through 4 (of 4 total)

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