Post reply

Really need help in writing data to a text file

  • February 12, 2012 at 8:55 am

    #255531

    Hi Guys

    I have used oracle to create a flat txt file using UTL.

    I am now really struggling to understand the concept of writing data to a text file in sql server.

    I have to pretty much produce a flat file which produces data from a table called users. (ID, LOGINNAME, FORENAME SURNAME) are the columns i require to extract from the users table.

    I am stuck on how it works in sql server. Any chance I could get some help please?

    Many Thanks

  • February 12, 2012 at 10:24 am

    #1446053

    two ways basically -

    Using a command line utility called bcp

    Or use SSIS. You get started with that by using using the wizard from SSMS. Right click the database and choose export data. Follow the screens, they are intuitive. A task is created you can execute there and then, or schedule for later, or both.

    ---------------------------------------------------------------------

Viewing 2 posts - 1 through 2 (of 2 total)

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