SQL Svr 2000: DTS - "invalid pointer"

[Gweener]

All

I've created a query in query analyser to update a table through data derived from another.

The query i have written works fine in query analyser, produces the results and if i add an "insert" statement, will update my destination table.

However, if i try and set this up using the DTS wizard (via the export function on the right-click menu), on execution it errors giving me an "invalid pointer" message.

Can anyone shed any light?

 

[JBaileys]

You may want to try to run the process outside of the DTS wizard. Set-up the DTS job manually.

The other option is to scrutinize the DTS export job and verify the components (data sources, transformations, etc.)

 

[donutman]

So you have a SP that works in QA? And when you try to use DTS with it, it fails? BTW, why are you making it a DTS package (just curious)?
-Karl

 

[Gweener]

My skill set is too low (but climbing) to use anything but the DTS wizard....will try same thing with manual creatio.

My requirement is to query a database and update another (summary information) database. DTS wiz is the best way I know of doing this.

I could obviously create a stored procedure - but it's the automation of it I am unfamiliar with.

 

[Gweener]

Have it working with manually created DTS (manual DTS seems very easy)!

Karl, interested in using stored procedures - if you have the time and/or inclination, i'd be interested in your input (or point me to a learning resource).