In your DTS package, you will need a Transform Data Task, which will be
created by default if you use the import data wizard. Open this task (by
double clicking), and you should see a dialog box with tabs for Source,
Destination, Transformations, Lookups and Options. Choose the
Transformations tab and you'll see all of the transformations currently set
up. Click the New button and choose ActiveX Script. Now you'll see a
dialog with tabs for General, Source Columns and Destination Columns. Click
on Source Columns and select your column. Click on Destination Columns and
choose your destination columns. It doesn't matter that you have 1 source
and 2 destination columns. Then click on the General tab, and click the
Properties button. You're now editing your ActiveX script. You write it
pretty much just like a VB or VBA program. Play with this box for awhile
and I'm sure you'll figure the rest out. you can use some of the built in
VBScript functions to parse out the first and last names. You can also code
the whole thing in JScript, which is kinda like JavaScript, but different.
Hope that helps,
Bob
-----Original Message-----
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: May 1, 2001 5:53 PM
To: CF-Talk
Subject: RE: seperate data
The column is call name that it is in one database and it includes the
lastname and the first name seperated by a coma. I am using a DTS package
to pull this data into my sql server. I want to know how to seperate these
two and put them into two columns: FNAME and LNAME
> -----Original Message-----
> From: Clint Tredway [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 4:58 PM
> To: CF-Talk
> Subject: Re: seperate data
>
>
> Do you mean that the fname and lname are in the same column?
>
> If they are are you wanting to split these into two seperate columns?
>
> I apologize for asking, but your request is a little vague.
>
> Clint
>
> ---------- Original Message ----------------------------------
> From: "Joshua Tipton" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Tue, 01 May 2001 15:47:59 -0400
>
> I have a column in an sql table that has the lname, fname. I want to
> seperate this out in an sql table. What is the code that I can run in dts
> to seperate these two.
>
> Thanks,
>
> Joshua Tipton
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
