Re: DTS export from SQL query to csv file fails with invalid pointer

#1

And what is the query.

I have seen this error mentioned when there is a USE statement as the first
part of the query.

What about reregistering DTSFFile.dll

What SP of SQL Server?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ed Ireland" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Quote:

I'm pretty short in the experience area here so this is
probably something pretty easy. Any help would go a long
way!

I'm trying to use DTS to create a .CSV/.TXT file that
stores the results of a simple query.

The query runs OK by itself, but the DTS action fails
with "Invalid Pointer" when it executes. The task goes as
far as creating a file where it is supposed to, but the
file is 0 bytes in size.

The Step Name is "Copy Data from Results to
C:\Temp\sample.csv Step"

This is running under SQL2000 on Server 2000 OS.

Thank you in advance.

Ed Ireland

#2

Following is the simple query.

use MP2Samp
select wonum, left(closedate,11)as closedate, equip.eqnum,
description from
woeqlist left outer join equip on woeqlist.eqnum =
equip.eqnum
order by wonum asc

You were correct regarding the USE statement--thank you.
Once "USE MP2Samp" was removed, the DTS ran under the
immediate execution option. For some reason though, the
DTS is not running against the schedule that I assigned of
every 8 hours.

The service pack is 8.00.534 Database Components Service
Pack 2 (SP2)

Quote:

-----Original Message-----
And what is the query.

I have seen this error mentioned when there is a USE
statement as the first
part of the query.

What about reregistering DTSFFile.dll

What SP of SQL Server?

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Ed Ireland" <anonymous (AT) discussions (DOT) microsoft.com> wrote
in message
news:213201c4176b$60f7ab40$3501280a (AT) phx (DOT) gbl...
I'm pretty short in the experience area here so this is
probably something pretty easy. Any help would go a
long
way!

I'm trying to use DTS to create a .CSV/.TXT file that
stores the results of a simple query.

The query runs OK by itself, but the DTS action fails
with "Invalid Pointer" when it executes. The task goes
as
far as creating a file where it is supposed to, but the
file is 0 bytes in size.

The Step Name is "Copy Data from Results to
C:\Temp\sample.csv Step"

This is running under SQL2000 on Server 2000 OS.

Thank you in advance.

Ed Ireland

.

#3

Ed Ireland is a complete and total ass. He has no clue whatsoever. Don't attempt to help him, you are just wasting your time!

From http://www.developmentnow.com/g/103_...id-pointer.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DTS export from SQL query to csv file fails with invalid pointer

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

Re: DTS export from SQL query to csv file fails with invalid pointer - 04-01-2004 , 02:22 AM

Re: DTS export from SQL query to csv file fails with invalid pointer - 04-02-2004 , 10:38 AM

RE: DTS export from SQL query to csv file fails with invalid pointer - 01-29-2010 , 12:27 PM