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 - 2000-11-03 : 13:11:37
|
Carrie writes "Hi there-
I asked a DTS question a while ago that you sent me extremely valuable information about, so I thought I'd try again!
We were trying to set up a DTS package using the wizard. We wanted to call a stored procedure to create the data source, so we put the proper code to execute this stored procedure into the wizard.
This stored procedure is rather complicated, and involves creating temp tables as well as using a linked server to connect two separate databases. When we enter our execute statement into the DTS wizard and hit the "parse" button, we get the following error:
Error Source: Microsoft OLE DB Provider for SQL Server
Error Description: Invalid Object Name '#ActivityObjectTypes'
So my question is - is there a limitation to the type of SQL query you can execute from within a DTS package?
We're using SQL 7.0 on an NT 4.0 server." |
|
|
|
|
|
Using SQL query as data source in a DTS package