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 |
|
majnoon
Starting Member
26 Posts |
 Posted - 2002-02-22 : 07:01:06
|
| Hi All:Is there a way to script a data export both to a flat text file and an access db from SQL2KWishing you a peaceful journey |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-02-22 : 07:03:48
|
| DTS would allow you to perform both operations. You would create connections for your SQL Server, a text file, and your Access database, then create Transform tasks between both SQL Server and text, and SQL Server and Access. Then you set the properties on each transform to run the query that outputs the data for you. |
 |
|
|
|
|
|
Export