This time I've wrote a stored-procedure to export data to a DBF file using DTS.
The procedure works fine in Query-analyzer but gets the error "invalid pointer" during DTS.
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:Invalid pointer
I've got the workaround but not the reason.
- add the following statement to the beginning ... and the error's gone.
SET NOCOUNT ON
ps: I'm using MSDE only.
Subscribe to:
Post Comments (Atom)
5 comments:
Rick -
You're "work around" is genius - I've worked at / around the "simple query" aspect of the DTS transform for years, and never thought of "set nocount on".
Pure genius - and THANKS!
Hi Rick:
Your comment did the trick - set nocount on worked!!
Thanks,
JT
Hi, I have the same exact issue: script executes fine, parses without any errors as well, but fails in DTS with an "Invalid Pointer" error.
However, I have the "work around" in there already and it does not help. :(
Can you help?
Thanks.
Absolutely spot on, thanks for the post it worked perfectly :D
Hi there, just was aware of your blog thru Google, and found that it's truly informative. I am going to watch out for brussels. I’ll appreciate should you proceed this in future. Numerous other people can be benefited out of your writing. Cheers!
Fine website. Hold responsible you!
[url=http://www.teenfotzen.info ]mydirtyhobby Amateurpornos[/url]
[url=http://www.hotteens2010.de.vu]porno[/url]
[url=http://www.pornme.com/?ref=1397&fsk=18]live sexcam[/url]
Post a Comment