Writing header records to the destination.

#1

I'm using DTS to copy files from SQLServer to a txt file. I would like to
add a header row and trailer row to the txt file. I've read that the
function "PreSourceMain()" is the place to do this. I'm using VB.net to run
the DTS script
Let's say that I just wanted to put a datetime stamp and a file name as the
header record, how would I do this?

#2

Hi

The easiest way may be to use an activeX scripts task and the
FileSystemObject.

http://www.sqldts.com/default.aspx?292
http://msdn.microsoft.com/library/de...gwithfiles.asp
in a similar way to: http://www.sqldts.com/default.aspx?256

John

"Eddie Suey" <esuey (AT) inBizServices (DOT) com> wrote

Quote:

I'm using DTS to copy files from SQLServer to a txt file. I would like to
add a header row and trailer row to the txt file. I've read that the
function "PreSourceMain()" is the place to do this. I'm using VB.net to
run
the DTS script
Let's say that I just wanted to put a datetime stamp and a file name as
the
header record, how would I do this?

#3

I don't have access to the Axscphst DLL. I need this to run the scripts
- don't I?

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

#4

In article <#npROO1lDHA.3688 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, esuey
<esuey (AT) hotmail (DOT) com> writes

Quote:

I don't have access to the Axscphst DLL. I need this to run the scripts
- don't I?

If you haven't got Axscphst.dll installed and registered then you will

get some nice big errors when trying to use an ActiveX Script in your
package, e.g.

ActiveX Scripting Initialization Error
(http://www.sqldts.com/default.aspx?224)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Writing header records to the destination.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Writing header records to the destination. - 10-10-2003 , 01:55 PM

Re: Writing header records to the destination. - 10-11-2003 , 12:45 PM

Re: Writing header records to the destination. - 10-20-2003 , 04:46 PM

Re: Writing header records to the destination. - 10-28-2003 , 12:00 PM