I am a total newbie and have a question to ask. I am the only DBA on a team managing several SQL servers and we have a new project that require the creation of a CVS flat file.
I was give a note pad document with ASP script and (here is the crazy part) I don’t know what to do with it.
What’s also weird is that the DBA that gave it to me said it’s a very old version of ASP that it was done in and at the top of the script it says
<%@ language="vbscript" %>
<!--#include file="Connections/connSecurity.asp" -->
Also a user needs to enter a start and end date and can enter SSN to get specific info.
Is there a way to implement Report Server to generate CVS Flat files and maybe use this script
Can i design this using Report Server alone.
Please let me know. Your help is appreciated.
wow I have more questions than answers for you, sorry:
Generally a DBA will use SQLCMD.exe, BCP.exe, SSIS or maybe a custom CLR to export data to disk, whehter it's csv,tsv or some other format.
A developer might write code or a web page to do the same thing, but one step removed from the data.
Why do you need to use an asp page to do it, instead of the tools a DBA would typically use?
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!