So you're using a table in SQL Server to send the data to the package? And you've verified everything in the table is correct?
And the job is using the correct server name?
If this is true, one of the settings in the package itself is overriding your config values. Try going through the package and blanking out all the variable references that are set to look in the config table.
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.