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)
 Create a .dat and insert a trailer record

Author  Topic 

dowens
Yak Posting Veteran

82 Posts

Posted - 2008-02-27 : 11:57:42
DTS SQL 2000

A view is used to create the .dat file.
I need to insert a trailer record at the end of the file.
Trailer record char(36)
Record Count char(7)
Date
filler space(25)

Example:

TRAILER RECORD DATA 737 MMDDYYYY

Looking for help!!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-02-27 : 12:24:17
Try using a ActiveX script
Go to Top of Page

dowens
Yak Posting Veteran

82 Posts

Posted - 2008-02-27 : 12:26:14
I have no experience with ActiveX script.
Go to Top of Page
   

- Advertisement -