DTS export from SQL query to csv file fails with invalid p..

External Since: Mar 31, 2004 Posts: 2

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

External Since: Oct 01, 2003 Posts: 1481

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)
<a rel="nofollow" style='text-decoration: none;' href="http://www.SQLDTS.com" target="_blank">www.SQLDTS.com</a> - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - <a rel="nofollow" style='text-decoration: none;' href="http://www.sqlpass.org" target="_blank">http://www.sqlpass.org</a>

"Ed Ireland" wrote in message

> 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