if statement Active X in DTS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

if statement Active X in DTS

Author

Topic

jung1975
Aged Yak Warrior

503 Posts

Posted - 2005-08-03 : 11:09:46

Can I use IF statement in Active X script?:

For example:
If DTSSource("RX") = "Yes" then
DTSDestination("RX") = "Y"
end if
If DTSSource("DX") = "No" then
DTSDestination("DX") = "N"
end if

jung1975
Aged Yak Warrior

503 Posts

Posted - 2005-08-03 : 16:50:45

Can I do something like this using ActiveX in DTS?

Funcation Main()
If DTSSource("City") = "Newyork"
then "Seoul"
end if
DTSDestination("City") = DTSSource("City")
Main = DTSTransformstat_OK
End function

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources