exactly but the transformation in the dts looks like it will only take a single file
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Phil Rasmussen Sent: Monday, November 17, 2003 1:16 PM To: CFAussie Mailing List Subject: [cfaussie] Re: DTS 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 --- 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
