An SQL query that can generate flat ascii files in the following format:
Header Record indicated with H and some header fields.
Detail Record indicated with D and some Detail record fields.
Trailer Record indicated with T and some trailer record fields.
Most of the information contained in Header and Trailer is static information. Trailer does contain the total number of transactions and the total amount for each transaction.
The database is SQL Server 2008 and the SQL query should be able to generate the flat ascii file with the mentioned requirements. More information will be provided to the suitable candidate.
24 freelancers are bidding on average $296 for this job
Already done something very similar. I can develop it in SQL as your request or propose a very small .net program (it requires less privileges on the server).
Hi , Vewold Technology is emerging company with skilled professionals in Database development and analysis. We will be glad working on this project. Please consider us for the same and revert back. Thanks
As per description you need SQL job to run manually or period to generate ascii files of sql data. If I am thinking right or have close of your requirement so please contact with me via mail.