DTS Importing Blues -- Can anyone help?

[Anthony M. Williams]

I am importing via DTS a .csv file. I have 2 issues:

-One field from the source needs to be inserted into two existing fields.

-Two fields from the source, First_Name and Last_Name need to be
concatenated to a destination field, Full_Name.

I do not know VB but I do know SQL.

Can anyone help?

[Glen]

Let's start from the second. On the DTS designer screen highlight two fields LastName and FirstName from the source;then select ActiveXscript and pull from the destination field to selected fields. VBscript panel opens. Enter something like:
DTSDestination("FullName&#34 = DTSSource("Col011&#34& " " & DTSSource("col012&#34
Main = DTSTransformStat_OK

First is even simpler. Select destination field,select ActiveXscript;pull destination to the source. In VBscript panel enter what part of the field you need. Repeat the same operation for the next field.


------------
Anthony M. Williams at 11/18/99 11:04:20 AM

I am importing via DTS a .csv file. I have 2 issues:

-One field from the source needs to be inserted into two existing fields.

-Two fields from the source, First_Name and Last_Name need to be
concatenated to a destination field, Full_Name.

I do not know VB but I do know SQL.

Can anyone help?

[Anthony Williams]

Glen, Thanks! One more problem.

Now I get a login failed error after I made the changes. I feel I have tried everything but i still
get this error. I am using sa and I have tried an sa equilivant.

Have you run into this before.


------------
Glen at 11/18/99 11:33:42 AM

Let's start from the second. On the DTS designer screen highlight two fields LastName and FirstName from the source;then select ActiveXscript and pull from the destination field to selected fields. VBscript panel opens. Enter something like:
DTSDestination("FullName&#34 = DTSSource("Col011&#34& " " & DTSSource("col012&#34
Main = DTSTransformStat_OK

First is even simpler. Select destination field,select ActiveXscript;pull destination to the source. In VBscript panel enter what part of the field you need. Repeat the same operation for the next field.


------------
Anthony M. Williams at 11/18/99 11:04:20 AM

I am importing via DTS a .csv file. I have 2 issues:

-One field from the source needs to be inserted into two existing fields.

-Two fields from the source, First_Name and Last_Name need to be
concatenated to a destination field, Full_Name.

I do not know VB but I do know SQL.

Can anyone help?

[Glen]

It just tells me that you didn't add a MS OLE DB connection to your DTS. Send me e-mail on second address tomorrow ( work ) and I will give you details...


------------
Anthony Williams at 11/18/99 2:32:59 PM

Glen, Thanks! One more problem.

Now I get a login failed error after I made the changes. I feel I have tried everything but i still
get this error. I am using sa and I have tried an sa equilivant.

Have you run into this before.


------------
Glen at 11/18/99 11:33:42 AM

Let's start from the second. On the DTS designer screen highlight two fields LastName and FirstName from the source;then select ActiveXscript and pull from the destination field to selected fields. VBscript panel opens. Enter something like:
DTSDestination("FullName&#34 = DTSSource("Col011&#34& " " & DTSSource("col012&#34
Main = DTSTransformStat_OK

First is even simpler. Select destination field,select ActiveXscript;pull destination to the source. In VBscript panel enter what part of the field you need. Repeat the same operation for the next field.


------------
Anthony M. Williams at 11/18/99 11:04:20 AM

I am importing via DTS a .csv file. I have 2 issues:

-One field from the source needs to be inserted into two existing fields.

-Two fields from the source, First_Name and Last_Name need to be
concatenated to a destination field, Full_Name.

I do not know VB but I do know SQL.

Can anyone help?