|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/30/2009 8:59:35 AM
Posts: 3,
Visits: 13
|
|
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?
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/30/2009 8:59:35 AM
Posts: 3,
Visits: 13
|
|
|
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.
|
|
|
|