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 |
|
Butterfly82
Starting Member
30 Posts |
 Posted - 2008-01-28 : 22:00:18
|
| Hi there, Does anyone know any possible way of creating a dbf file from within a stored procedure?Any guidence, articles, examples, topics to revice would be a great help. Thanks guysButterfly82 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-28 : 22:16:38
|
| You can run dos command with master..xp_cmdshell in sp. |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-30 : 01:53:00
|
| Do you want to create the file to save a particular recordset or do you want to transfer data?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
Butterfly82
Starting Member
30 Posts |
Posted - 2008-01-30 : 09:38:55
|
quote:
Originally posted by rmiao
You can run dos command with master..xp_cmdshell in sp.
Hi Rmiao, Thanks for your reply. What dos command is it that I can run to achieve this?RegardsButterfly82 |
|
|
|
Butterfly82
Starting Member
30 Posts |
Posted - 2008-01-30 : 09:40:49
|
quote:
Originally posted by jackv
Do you want to create the file to save a particular recordset or do you want to transfer data?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com
Hi Jack, At the moment I just want to transfer data to a dbf file from sql server within a stored procedure.RegardsMelanie |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-01-31 : 05:10:53
|
| Have you considered using DTS (SQL Server 2000) or SSIS (2005)?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-02 : 00:05:39
|
| Or via linked server in sp. |
|
|
|
|
|
|
How to create a dbf file from a stored procedure?