September 1, 2008 at 2:37 am
I've got a simple DTS package that does a handful of updates on tables. The updates run fine on QA, parsing fine, but when parsed in the DTS designer, I get
"Invalid objcet name lgnom_partyaddress"
This is a table in the database. I thought for a moment I'd typed 'I' instead of 'L' as the first letter, but checked by copying the text into QA and parsing it fro there.
Anyone got any ideas?
September 2, 2008 at 5:10 am
Are you running the package in same database as you use when trying in QA?
N 56°04'39.16"
E 12°55'05.25"
September 2, 2008 at 7:23 am
Actually that's about what we found, when we fixed it.
The DTS had been written on one server, and the dbo seems to be different for that table (??)
When copied to the live server, becuase the coding happily assumed the owner - no dbo. - it hit the problem.
Adding the 'live' owner to the script sorted it out. Having never done anything that strange before, the error threw me a bit.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply