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.
Chief Technology Officer http://www.bcd2000.com
-- all of the technology products at one low price --