Home Forums Data Warehousing Integration Services Upgraded Package from 2k5 to 2k8 with configuration having problems with driver swap RE: Upgraded Package from 2k5 to 2k8 with configuration having problems with driver swap

  • Checked the XML on the source file. First I removed the data source entirely (though two of my other configurations are relying on it) and checked the XML.

    I can find two calls to it (same as the # of configs involved with it) ... one from the environment variable and the other for the configuration that relies on it.

    I've yanked logging out as well, and that hasn't removed the issue.

    I managed to, alchemically, fix one of the packages to stay in 10.1. I have absolutely no idea how I did it. When I got back to the package it had swapped the Environment Variable into a called configuration from a sql table. Reversing this to an environment variable corrected the problem for that package... and even attempting to replicate that process doesn't fix the issue for other packages.

    I'm stumped.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA