[cfaussie] Re: DTS

[Phil Rasmussen]

So just to get a picture in my head, you want to loop over a series of 
txt files, and transform the data in each file into your mssql tables. 
If this is the case then you should use a single DTS package that runs 
an ActiveX script as its transformation method, and in that activex you 
open each text file and transform its data into availble MSSQL 
destination fields. Is this what you are looking at doing?

Phil

Steve Onnis wrote:

Basically I want to run a transformation to import data from text files into
a database
I have the code all done to get all the files I need to extract the data I
need, but the code I used for the tranformation is not right.
I grabbed a DTS I exported as VB, and used that code to do the
transformation, but I am looping over it a few times, and its trying to
create a new DTS package each time, which is not really what I want to do.
Steve

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Phil
Rasmussen
Sent: Monday, November 17, 2003 10:53 AM
To: CFAussie Mailing List
Subject: [cfaussie] Re: DTS
Yeah Steve what are you trying to do exactly?

Steve Onnis wrote:

Anyone here done much with MSSQL and DTS?

Trying to get some VB to run on the dam thing

Steve




---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004




---
You are currently subscribed to cfaussie as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia
http://www.mxdu.com/ + 24-25 February, 2004