Post reply

SSIS Configuration with 2012 and 2008 R2 Question

  • May 7, 2012 at 10:55 am

    #260526

    Trying to find out if this is possible...

    Can a SQL Server 2012 machine acting as a SSIS App Server (running the SQL Job that does the execution) connect to a HA\DR environment where the actual package and table configurations are stored and be able to run the package/get the configuration information?

    What about if the SSIS App Server were the 2008 R2 machine and the HA\DR environment was running SQL Server 2012? Could this work?

    Thanks for any and all responses. I myself will continue to research.

    Thanks

  • May 8, 2012 at 12:14 am

    #1484326

    When you run the job on a server, the package will be copied to that server. So the package itself will not be executed on the HA/DR environment where it is stored, but on your SSIS server. Which is the point I guess 🙂

    It doesn't really matter where your configurations are stored, as long as you have a valid connectionstring pointing to them.

    Regarding the different versions: 2008 cannot execute 2012 packages and 2012 will upgrade 2008 packages before executing them.

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

  • May 8, 2012 at 6:00 am

    #1484445

    Thanks Koen for the reply...do you have a URL's with this information in it?

    Thanks Again...

Viewing 3 posts - 1 through 2 (of 2 total)

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