dbTalk Databases Forums  

Re: Invalid pointer message

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Re: Invalid pointer message in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Spencer Maiers
 
Posts: n/a

Default Re: Invalid pointer message - 07-03-2003 , 06:00 PM






I had this same issue, and what fixed it for me was removing the "USE
<database_name>" clause at the top of the query.

I.E., my query looked like this:

USE Northwind
SELECT * FROM MyTable

If I just export from the correct database, I can do away with the USE
Northwind statement and simply have my query looking as-such:

SELECT * FROM MyTable

Then it worked for me.

Hope this helps in time!

Thanks,

Spen

Rinu Varghese <anonymous (AT) devdex (DOT) com> wrote

Quote:
Hello!

I need help with one of my SQL 7 severs. I'm trying to export data
based on a query to a text or excel file. When I execute it, I'm
getting an invalid pointer message.

Any input is greatly appreciated.

Thanks



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.