Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Executing cmd file with isqlw command imbedded, want to change output file delimiter Expand / Collapse
Author
Message
Posted Monday, March 17, 2008 2:02 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 5, 2016 9:29 AM
Points: 1, Visits: 58
I am running isqlw in scheduled command files. I have many vendors I SFTP files to within those command files. They require different output delimiters. Can you change the SQL Analyzer configuration from TAB to PIPE delimiter dynamically in the command file?
Post #470481
Posted Monday, March 17, 2008 4:16 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 9:45 PM
Points: 40,992, Visits: 38,289
Use BCP for this... and use OSQL instead of ISQL...

--Jeff Moden
"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

Helpful Links:
How to post code problems
How to post performance problems
Post #470561
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse