May 9, 2003 at 9:12 am
I am bringing over some data from an AS400 file and there data contains one char as a blank when it is transfered over into MSSQL.
If it was only a few columns I would be able to handle this, but there are a large amount of columns were this exist and I need to correct it. Any suggestions are welcomed!
-JG
-JG
May 11, 2003 at 7:09 pm
1) In the Transformations tab of DTS properties. Double click on the line from the column that you want to transform to nulls. This should bring up a VB Script.
2) In the VB Script entry form do the following (replace SrcCol w/ your source column name and DestCol w/ the destination column.
if isnull(DTSSource("SrcCol")) = True Then
DTSDestination("DstCol") = null
else
DTSDestination("DstCol") = DTSSource("SrcCol")
end if
3) Click Parse
4) Click OK
Darren
Darren
May 19, 2003 at 10:24 am
I appreciate the code. I was looking for a way to do this for a large number of columns. I have over a hundred columns in the table and wanted to prevent sevral lines of code for each. Is there a another function to perform this?
-JG
-JG
May 20, 2003 at 5:59 am
Trying to do manipulation in the transfer is not always a great idea. I would suggest writing a dynamic script that cycles through the columns in the sql table and updates the columns to null where it is a empty string.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy