how to create a flat file in client machine

• shamshudheen

  SSCrazy

  Points: 2390

  More actions

  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

• tbeadle

  SSCommitted

  Points: 1635

  More actions

  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]