Allan Mitchell
2004-04-01 07:22:44 UTC
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
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
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
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