Hello,

I am trying to use DTS to download certain columns from a table into a text
file. Currently, the package runs once per day and I am able to download the
whole table into a text file. However, I only need certain columns of the
original table. I see that the functioanlloty is there, but I am receiveing
an error. Here are the steps I am using.

1. Open the DTS import/export wizard
2. Choose a data source - no problem
3. Choose destination - no problem
4. Choose middle option - use a query to specify the data to transfer
5. Build the query
6. Choose all rows.
7 - When I hit the next button after choosing all rows I see the query I
just built. Then when I hit the next button again I get the following error

"Error Source: Microsoft OLE DB Provider for SQL Server

Error Description: Deferred prepare could not be completed.
Statement(s) could not be prepared.
Invalid object name 'OPPORTUNITY'

Context: Error calling GetColumnInfo. Your provider does not support all
the interfaces/methods required by DTS."

I am SQL Server 200 SP3

Thank you for your help.
John

I found the answer myself which was really simple. When choosing the source,
there are fields for logging into the databse. I was logging in as SA. If I
logged in as Sysdba, everything worked perfectly. I know nobody answered
this one, but thought some of you might be interested in the solution.

Thank you
John

"John Lloyd" wrote: