Post reply

how to create a flat file in client machine

  • May 27, 2008 at 4:47 am

    #188171

    Hi,

    I WOULD WRITE A STORE PROCEDURE, WHICH WILL CREATE VIEW SCRIPT AS A FLAT FILE WITH EXTENSION .SQL IN THE CLIENT MACHINE NOT IN THE SERVER.I DONT KNOW WHETHER IT IS POSSIBLE.ANY ONE HAS IDEA IS HIGHLY APPRECIATED

    THANKS IN ADVANCE

    SHAMSU

  • May 28, 2008 at 2:42 pm

    #821472

    [font="Arial"]

    Hello,

    Your post is some what criptic.

    If I understand correctly, you want to have a sproc create dynamic SQL into an output file with the extention of .sql on the client machine and not the server.

    If this is what you are asking, you can do it by creating a .bat command file on the client's machine. Then within the .bat have osql call a stored procedure that will build the dyanamic sql statement you want built. Have the sproc store the sql as text in a table. Then use bcp to output the sql statement to yoursproc.sql by reading the sql text.

    Let me know if this is not clearly stated.

    Regards,

    Terry

    [/font]

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

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