Home Forums SQL Server 2005 Business Intelligence SSIS package using wrong configuration settings RE: SSIS package using wrong configuration settings

  • August 6, 2013 at 7:21 am

    #1638912

    I've tested the Run Package in the GUI using the Test config file and verified that it's looking for my source file in Dev instead of Test.

    So I pulled down the Test config file to my desktop to ensure it's only pulling from that. I've opened the package in BIDS, and verified that my DFT Source is pointing to the Test NAS share. When I execute the task, it fails because it doesn't see a file in the Dev environment. How terribly annoying this is getting.

    I've got to catch this path switching in the act if i'm going to resolve this issue, i Think.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.