Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-23 : 14:28:57
|
Mike writes "I am using the DTS Export Wizard to export records from a SQL 2000 table to a Text File. My problem - the text file name will change with each export. I would like to have the process prompt for the file name to save to, and then write the recordset to that text file.
I have been able to create an ActiveX task using the FileSystemObject to create the text file, but, I'm not sure how to tag this into the export process so it saves to that text file.
I've searched the boards high and low but to no avail, so here I am. Can you help?
Thanks
Mike" |
|
|
|
|
|
DTS export to text file with Save File Name prompt