Executing cmd file with isqlw command imbedded, want to change output file delimiter

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Vince Iacoboni » Executing cmd file with isqlw command...

Executing cmd file with isqlw command imbedded, want to change output file delimiter

Rate Topic

Display Mode

Topic Options

Author

Message

terrell.sharp

Posted Monday, March 17, 2008 2:02 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, February 21, 2013 7:26 AM
Points: 1, Visits: 45

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

Jeff Moden

Posted Monday, March 17, 2008 4:16 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:18 AM
Points: 33,112, Visits: 27,038

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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #470561

« Prev Topic | Next Topic »

Permissions