Printable View
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?
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") = DTSSource("Col011")& " " & DTSSource("col012")
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, 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") = DTSSource("Col011")& " " & DTSSource("col012")
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?
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") = DTSSource("Col011")& " " & DTSSource("col012")
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?