Need help with a Export

Question

Need help with a Export

downes

SSC Eights!

Points: 840
More actions
February 27, 2008 at 6:39 am

#70814

DTS SQL 2000
A view is used to create the .dat file.
I need to insert a trailer record as 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!!!:unsure:

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Norman Kelm SSCommitted Points: 1922 More actions · Answer 1

Hi Debra,

The technique that I have seen is to write the trailer data to a separate file and concatenate the files at the DOS level. You could also use the FileSystemObject in an ActiveXScript Task to combine the view file and the trailer file.

Norman Kelm

DTS Package Search

http://www.dtspackagesearch.com/

downes SSC Eights! Points: 840 More actions · Answer 2

Hi Norman,

I do not have the knowledge to write a ActiveXScript Task.

Any help would be greatly appreciated!;)

Norman Kelm SSCommitted Points: 1922 More actions · Answer 3

Great examples here: http://www.sqldts.com/292.aspx

Here is code that opens a file for append

strFile = "c:\output.txt" ' e.g. c:\output.txt

' ------ END CONFIGURATION ---------

const ForAppending = 8

set objFSO = CreateObject("Scripting.FileSystemObject")

set objFile = objFSO.OpenTextFile(strFile, ForAppending, True)

objFile.WriteLine("Script completed: " & Now)

objFile.Close

Norman Kelm

DTS Package Search

http://www.dtspackagesearch.com/

downes SSC Eights! Points: 840 More actions · Answer 4

Thanks, Norman

objFile.WriteLine("How do I reference the trailer row here?")

strFile = "c:\output.txt" ' e.g. c:\output.txt

' ------ END CONFIGURATION ---------

const ForAppending = 8

set objFSO = CreateObject("Scripting.FileSystemObject")

set objFile = objFSO.OpenTextFile(strFile, ForAppending, True)

objFile.WriteLine("Script completed: " & Now)

objFile.Close