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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-25 : 12:13:28
|
Andrew writes "SQL Server 7.0 (7.00.699), Windows NT 4.0 Server SP 4
I have a DTS package that I developed in my test environment that connects to a SQL database (using OLE DB provider for SQL Server) and performs a load of data from existing tables into another table in that same database. The query to do this uses temporary tables. This works in testing.
When I try to implement this same package in production, I get an error. When I say I'm implementing it in production, I mean that I am connecting to the database on the production server using the same OLE DB provider for SQL Server and attempting to execute the same SQL Task query as mentioned before that uses temporary tables. The text of the error follows:
Error source: Microsoft OLE DB Provider for SQL Server
Error Description: Invalid object name '#Rev'.
I am thinking it may have something to do with the settings on the prodcution server versus the development server I am using. I did not do the original configuration of either. Any thoughts would be greatly appreciated.
Thanks" |
|
|
|
|
|
DTS OLE DB Error