run sql 2008 ssis package in sql 2012 machine

  • Hello,

    I have created a ssis package in sql server 2008 and use a job to execute it pointing to databaseA. works fine.

    Then, I place that package into a sql server 2012 machine and use a job to execute it in the same database, databaseA.

    The error I get is something like:

    can not use the old version in the new version machine.

    Is this really the case or am I doing something wrong please?

  • It really is the case. If you want to use it in SQL Server 2012 environment, you need to upgrade the package first.

    Normally SSIS does this for you, so I am interested in the actual error.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (5/12/2014)


    It really is the case. If you want to use it in SQL Server 2012 environment, you need to upgrade the package first.

    Normally SSIS does this for you, so I am interested in the actual error.

    Hello,

    I have included the error as attachment here.

    Note that the ssis package is saved and run in sql 2012

    Any suggestions please?

    Thanks

  • When do you get that error?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Koen Verbeeck (5/12/2014)


    When do you get that error?

    My apologies. I think I mis-guided you.

    Let me explain again:

    1- built ssis package in sql 2012. using a job to execute it. works good.

    2- now in sql 2008, would like to do the same thing i.e. use a job to execute that package.

    Question:

    Is this possible? i.e. going from 2012 to 2008?

    Thanks

  • No, you cannot downgrade an SSIS package.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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