create Sp data into txt file from table

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

create Sp data into txt file from table

Author

Topic

ramemail.n
Starting Member

8 Posts

Posted - 2010-07-27 : 09:49:12

i need to create a stored procedure the result should store in

test file in specific path..

example :

1) stock sim (select * from stock sim) with data time filter

every one day i am going to schedule

2) data should store in secific path with file name

D:\abc\stocksim@@date.txt

please help me out.

Rammohan N

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2010-07-27 : 13:45:24

i suggest you to use SSIS. it's fairly simple and straightforward.