Post reply

Creating a batch file to run multiple SELECT statements and output to a csv file.

  • September 12, 2004 at 7:07 pm

    #83656

    Creating a batch file to run multiple SELECT statements and output to a csv file.

    How do I the above in SQL Server 2000?

    Example code would be good as I am a SQL novice.

     

  • September 13, 2004 at 6:40 am

    #522718

    You can do this in data transformation services (DTS).

    Easiest way is to open the DTS folder in Enterprise Manager and follow these steps.

    1. Right click Local Packages, New Package

    2. Create a source connection (this can be from any datasource, sql, odbc, text file, etc)

    3. Create a destination connection select text (destination) type.

    4. You will need a Transform Data Task for each sql query that you need to run.

    5. After you have completed the package, you can schedule it to run, or call it from a procedure.

     

  • September 13, 2004 at 3:00 pm

    #522838

    Hi David

    Thank you very much for the info.

    An example would be good as I am new to SQL programming.

     

  • September 13, 2004 at 3:23 pm

    #522844

    Hello.

    If you still need a more detailed example then you may want to use the Build Query button in the Transform Data Task.  This option will give you a GUI that beahves somewhat like MS Access.

    If you need more detailed than that then you may want to state specifically which step is giving you trouble.



    Everett Wilson
    ewilson10@yahoo.com

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply