Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
DynDeveloper.com

DynDeveloper.com

Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now!Log In
steve gray 8/9/2011 7:24:59 AM

Writing to a Text File with SQL Server 2000

This article, along with other great articles, can be found on our SSRS General Index Menu.  

There are many tasks that call for writing to a text file. In order to get that done, we usually have to go into the .NET environment to get it done.

Here is a seriously nice piece of code that will allow you to write to a text file using SQL Server 2000. It makes use of the sp_OACreate and sp_OAMethod internal stored procedures to get the job done.

I use this method to write .vb classes, believe it or not. I have the code scan my database and write the data access code for my project. It's a huge time saver. If I write a new stored procedure, I rescan the database and all my data access code is updated, just that easy.

 

 

Version: Unknown or N/A
Section: SQL Scripts








Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables