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 - 2007-03-02 : 08:52:57
|
| santosh writes "Hi,Can I know how to save the output of a stored procedure into a specific folder with a specific file name in csv format using SQL/command prompt automatically without going into file-> save as? I need this task to be automated without going into file and save as everytime. I have used bcp utility but couldnt run a stored procedure using it. Can I use Data Transformation Services and if so how to design a package?Kindly help me on this with an example. Thanks in anticipation for your support." |
|
|
JohnH
Starting Member
13 Posts |
Posted - 2007-03-12 : 13:10:01
|
| I'd use DTS for this, because that's what I'm comfortable with. Search here or google for "DTS Tutorial" or "DTS CSV" and you should find help. It's not horribly hard, but there are too many details to put into a post, especially when there are some quite-good tutorials out there.John Hopkins |
 |
|
|
|
|
|
Automatically save output of a sp into a folder