Generating a text file automatically using SQL Server 2008

Question

I want to execute a Stored procedure in SQL Server 2008 and store the data in a text file. How to do this and how to generate a text file automatically with data in SQL Server 2008?

I would recommend checking out this link: thiagsundar.wordpress.com/export-data-to-text-file It shows a great way to export data to a text file from SQL Server. — Andrew Backes
– Andrew Backes, Commented Jul 15, 2012 at 3:55

vmvadivel · Accepted Answer · 2012-07-15 04:46:33Z

1

One of the method is to make use of BCP (Bulk Copy Program) to do this. You need to have xp_cmdshell enabled to get this working.

Also you can also make use of SSIS Import/Export wizard to achieve this.

EXEC master..xp_cmdshell 'BCP "exec dbname.schemaname.procname" queryout "C:\outputfile.txt" -T -c -t,'

Check out these:

BCP
SSIS

answered Jul 15, 2012 at 4:46

vmvadivel

1,0675 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Generating a text file automatically using SQL Server 2008

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related