Post reply

Exporting to a text file

  • September 22, 2003 at 10:40 am

    #65108

    I have a simple query that I'm running in a proc that I need to have the data exported from the proc to a text file that will be renamed each day with the current date (Ex. Output_092203.txt). I know you can export to a text file with DTS but I would like to know if you can do it from a stored procedure so I can rename the file.

  • September 22, 2003 at 10:52 am

    #475288

    Use BCP

  • September 22, 2003 at 10:51 pm

    #475344

    You can use the extended proc http://www.sqlservercentral.com/products/jgama/XP_file/ and write result string to a file.

    Cheers,

    Crispin

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • September 23, 2003 at 3:47 am

    #475366

    Use OSQL Utility

    DECLARE @CurrentDate VARCHAR(8) -- YYYYMMDD

    DECLARE @cmd VARCHAR(256)

    SET @CurrentDate = CONVERT(VARCHAR(8),DATEADD(DAY,0,GETDATE()),112)

    SET @cmd =

    'osql -E -SSrvName -Q "EXEC "DB..Proc" -o c:\OutFile' PLUS @CurrentDate PLUS '.txt'

    EXEC master..xp_cmdshell @cmd

    Replace PLUS with real PLUS

    The page don't accept PLUS in code so I put the word PLUS instead of real PLUS

  • September 23, 2003 at 8:55 am

    #475437

    See my thread 'Exporting to a text file from a stored procedure', in the T-SQL forum, 19-9-03.

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

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