September 24, 2004 at 2:33 am
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)
September 24, 2004 at 4:13 am
try the previous link to se if it helps.
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=93756#bm93832
this article may also help http://www.sqlservercentral.com/columnists/jsack/capturingtheerrordescriptioninastoredprocedure.asp
September 24, 2004 at 6:54 am
Thanks for your reply but I'd already seen that - exporting to a spreadsheet is not a problem - you can create a table using the dialog box easy enough - it's just when trying to export to a .csv, .txt or plain file that the error message occurs.
Has anyone else been able to export to a .csv?
September 24, 2004 at 8:18 am
sorted - it was a client problem - not sure what, but I've installed it locally adn it works as it did in SQL7 now...
Cheers
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply