scheduling SQL Assistance in SQL Server: setting delimiters in batch

Tools & Utilities

scheduling SQL Assistance in SQL Server: setting delimiters in batch

We're using SQL Server Enterprise Manager 8.0 to schedule multiple step SQL Assistance scripts and WINSCP file transfers (with dependencies - thus we are using SQL Server rather than Teradata Query Scheduler).

When I run under my own loginID, the scripts use the file delimiters (pipe '|') that are set in tools>options. But the jobs are being executed in SQL Server by a SQL Server manager and it is using tab delimiters. We cannot login as the SQL Server manager and change the SQL Assistance defaults for that login.

Has anyone changed the SQL Assistance registry for ExportDelim={tab} directly? How? Where?
1 REPLY

Re: scheduling SQL Assistance in SQL Server: setting delimiters in batch

I've since found the registry key to edit. In our SQL Server configuration, SQL Server Agent is using a .Default id when it executes the jobs. So the ExportDelim is being stored as a user. To change the registry, in a regeditor (and after you back up the registry), go to: HKEY_Users/Software/NCR/Queryman, then find the user: .Default and add the desired ExportDelim.