Home Forums Programming CLR Integration and Programming. Using an ASP RE: Using an ASP

  • May 17, 2013 at 12:24 pm

    #1616319

    jayoub1 (5/17/2013)

    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?

    Lowell

    --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!