Using a DTS package to take the results of a stored procedure and turn the results into a text file. That text file then gets uploaded for an advertising feed. The stored procedure is more / less just a query to pull the listings but had to be turned into a procedure so that the category listings could be built.

Already have the package built however when executing it returns with an error "invalid pointer". What might be causing this? Do I need to take the results of this stored procedure to a temporary table or a view then built the text file off of that?

Thanks in advance for any feedback.

Andrew Shelton
Chief Technology Officer
-- all of the technology products at one low price --