I have a batch job that runs that is querying data from SQL Server. I am then emailing the output of that query to a customer. Presently we are emailing a | delimited list, however the customer would prefer a tab delimited list. I have attempted using a char(9) in place of '|' but with no luck. Is there a way to accomplish this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Batch Tab Delimited Select
- Thread starter Signit
- Start date
fredericofonseca
IS-IT--Management
Depends on how you are doing things.
I have a particular process now that is setup as a DTS package.
This package issues a select on a table and outputs the result to a file. I then email the resulting file using a vbscript with vbsendmail.dll.
the first step consists of a connection to SQL Server and another one to "Text file (destination)". The settings of the destination file can be set to fixed or delimited, and the delimiter can be a tab.
Have a look at this possibility.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
I have a particular process now that is setup as a DTS package.
This package issues a select on a table and outputs the result to a file. I then email the resulting file using a vbscript with vbsendmail.dll.
the first step consists of a connection to SQL Server and another one to "Text file (destination)". The settings of the destination file can be set to fixed or delimited, and the delimiter can be a tab.
Have a look at this possibility.
Regards
Frederico Fonseca
SysSoft Integrated Ltd
- Status
Similar threads
- Locked
- Question
