try
IsNull(DTSSource(SourceCol
Main Topics
Browse All TopicsHello Folks:
I am (via DTS) copying a table from an ODBC Source (Notes yuc) into SQL. My SQL based destination table has several columns of numeric data with the "NOT NULL" constraint on. My probelm is, the source is not so constrained. My goal, when a NULL value is encountered, is to replace it with 0. To that end, I have written the below transform. I always get an "object required" error, or a type mismatch. (I have tried many permutations with IS NULL, = NULL, ISNULL, etc.) The fundamental question I have for you all: How can I tell that s DTS Source Value is NULL? It is probably simple, but I am missing it.
'*************************
' Visual Basic Transformation Script
'*************************
' Copy each source column to the destination column
Function Main()
DTSDestination("ReforcastD
DTSDestination("ReforcastN
' many more instructions. You get the idea.
DTSDestination("EstimateMa
DTSDestination("EstimateFe
DTSDestination("EstimateJa
Main = DTSTransformStat_OK
End Function
Function SourceOr0(SourceColumn)
if DTSSource(SourceColumn) = NULL then
SourceOr0 = 0
else
SourceOr0 = DTSSource(SourceColumn)
endif
end Function
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.

Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Business Accounts
Answer for Membership
by: jonleehackerPosted on 2003-12-17 at 11:29:18ID: 9958953
you said you tried ISNULL but was it in this format:
umn)) then
if IsNull(DTSSource(SourceCol