sql server dts: Active X trasnsformation, if - then

Active X trasnsformation, if - then - else

computer.mike NO[at]SPAM hotmail.com
10/22/2007 12:49:51 PM

sql server dts:

I am moving data from Access to SQL Server.

I have a term date field (datetime) whose source values in Access are
'1/1/1700'

I am using an Active X Transformation task to change those values to
'1/1/1753'

Here is my code

If DTSSource("TERM_DATE").value < '1/1/1753'
then DTSDestination("TERM_DATE").value = '1/1/1753'
else DTSDestination("TERM_DATE") = DTSSource("TERM_DATE")

can't figure out whats wrong

Mike

Re: Active X trasnsformation, if - then - else

jhofmeyr NO[at]SPAM googlemail.com
10/25/2007 1:37:24 AM

[quoted text, click to view]

Hi Mike,

What is the error you are getting? Also, what version of SQL Server
are you using (I'm assuming 2000?) Finally, why are you changing
these values in an ActiveX task instead of simply running an UPDATE
statement against the table?

Regards,
J