Hi,

I'm currently trying to get a DTS to export the results of a SQL query to a
..csv file.

It used to be really easy to do in SQL7 - set up a connection, set up the
destination file, set up the transform data task, set the source to a SQl
query and when you clicked on destination, you could choose to define
columns... done

When I try this in SQL2000, it's all the same until I click on destination -
there is a create table button button which when clicked shows the SQL for
creating a table, but when I click on it - I get the error message "No Such
Interface Supported". Has anyone experienced this before, and if so do you
know a way around it.

If I use the DTS export wizard - it works fine - but in this case I can't as
there are multiple steps that require csvs to be produced. I've searched for
quite some time to try and find out why this is and would appreciate any help
anyone could offer.

Cheers

Paul

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT
5.0 (Build 2195: Service Pack 4)

Because this works in the Wizard then I do not suspect
anything wrong with DTS per se.

Are you sure you have specified a Destination flat file as
the destination and not a Source flat file ?

Cheers for your quick reply...

I'm certain its the destination flat file I've specified as the destination
- I'm practicing on a dummy package with the same results - just a
connection, a destination file and a transform data task. I'm fairly sure
it's something to do with the error message "No such interface supported" but
as to what, I'm unsure - are you able to do it using SQL2000 then? Could it
be something to do with the setup of the server <clutching at straws> ;-)

Thanks again

"Allan Mitchell" wrote:

Cheers for your quick reply

I am certain that I have specified the file as a destination file and not a
source file - I have set up a dummy package to pratice on with just a
connection, a destination file and a transform data task. I think it has
something to do with the error message No such interface supported, but as to
what, I am unsure. Are you able to do this procedure? Could it be something
to do with the server setup? <clutching at straws> ;-)

Thanks again...

"Allan Mitchell" wrote:

Have a look to reregister the following file

dtsffile.dll

If you are sure that you

"Paulo" wrote:

sorted - works in teh same way I remember SQL 7 doing it now

what's all that about then?!

Thanks for your help!!

"Allan Mitchell" wrote:

Apply the Post-SP3 hotfix. I noted that you're running .760 which should be
SP3. The post SP3 fix brings you up to version .818 and fixes some issues
with DTS. You can find it with a little searching or call MS to get the
latest and greatest (.919, I think)

Refer to MSKB article 830887

To just get the fix in .818, go here:

http://www.microsoft.com/downloads/d...displaylang=en

-pete

"Paulo" <Paulo (AT) discussions (DOT) microsoft.com> wrote:

Try www.sqlscripter.com to export data to text/csv.
It's free.


"Paulo" wrote: