Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS output file formatting.

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-10-24 : 07:47:36
Troy writes "I am outputing a .txt file using a dts package. I am using Active X script to generate the txt file with a date time tag and .txt destination file to get the text file output.

i am gettin the output in this form.....

Database Last Backup Date Days Since Last Backup
Ab
AbArchive
AbVRU
AdventureWorks2000 2005-09-21 09:31:14 394
AIControl 2006-04-27 10:14:31 176
AIControl_Dev
AJ110 2005-10-23 00:00:35 362

As you can see its not formatted ...my question is , is there anyway i can format it in this form...

col1 col2 col3
----------------------------
data1 data1 data1
data2 data2 data2


so that its easier for the user to see it..."
   

- Advertisement -