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 |
|
skumawat221
Starting Member
1 Post |
 Posted - 2006-01-11 : 15:54:03
|
| I need to export a query result data to a file. Does SQL DMO provides a way to export SQL query data ? I am able to export Table, Views data using SQL DMO object but could not find a way to export a sql query data.We have option to write a "Select" query while manually Exporting data using Enterprise Manager.Can we do it programatically? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-01-11 : 15:58:33
|
| Yes you can. Do the export via a DTS package. Then save the DTS package as a VB file through the Save As...You can then check out the code.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Import/Export