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
 General SQL Server Forums
 New to SQL Server Programming
 Automatic Export on csv

Author  Topic 

Flaterik
Starting Member

26 Posts

Posted - 2012-07-03 : 10:55:12
Hi people,
i need that one View that i have just created, is automatically exported on .CSV files

How i can do this?



************************************************
the world is strange but people are crazy

slimt_slimt
Aged Yak Warrior

746 Posts

Posted - 2012-07-03 : 11:05:56
with view you can't automatically export to *.csv file.

you will need to do it otherway. there are many ways to do it. e.g.: SSIS package, bulk export, openrowset, etc.
Go to Top of Page

Flaterik
Starting Member

26 Posts

Posted - 2012-07-03 : 11:23:26
Perfect, how to use correctly Bulk Export?
I must use this from .bat file and schedule on windows

************************************************
the world is strange but people are crazy
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-07-03 : 19:10:54
quote:
Originally posted by Flaterik

Perfect, how to use correctly Bulk Export?
I must use this from .bat file and schedule on windows

************************************************
the world is strange but people are crazy


use bcp then.

see

http://www.simple-talk.com/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -