Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sk_ndiweni
Starting Member
2 Posts |
 Posted - 2009-01-13 : 19:16:19
|
| I have a DTS job that is failing on several objects in my database one view and 5 tables. The message I get a message saying "Invalid object name.." and give the name of the table or view. These objects do exist in the database and I have checked permissions and they are all the same as other objects the system does not have a problem with. I have even deleted and recreated the tables and it still fails on the same objects. Any ideas? I'm running on SQL server 2000. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-13 : 19:17:59
|
| Did you execute under correct database? |
 |
|
|
sk_ndiweni
Starting Member
2 Posts |
Posted - 2009-01-14 : 11:34:31
|
| The names of the tables are fully qualified databasename.dbo.table or view name. Other tables and views are similarly refrenced and there are no problems with those, just these particular objects. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-14 : 12:06:19
|
quote:
Originally posted by sk_ndiweni
The names of the tables are fully qualified databasename.dbo.table or view name. Other tables and views are similarly refrenced and there are no problems with those, just these particular objects.
can you check if dts is using correct connection settings at run time i.e whether its connecting to correct server and dbname? probably best to check your connection config values. |
|
|
|
|
|
|
DTS: Invalid object name error