Calling SP from inside VB transformation script

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)

Calling SP from inside VB transformation script

Author

Topic

bryan42
Starting Member

28 Posts

Posted - 2007-06-29 : 13:59:50

Inside a data pump, how do you execute a stored procedure in a VB Transformation script?

In a DTS, I need to encrypt certain fields before storing them in the destination database. So, when I link the source and destination columns I select 'activex script' and get this:

Function Main()
DTSDestination("SSN") = DTSSource("SSN")
Main = DTSTransformStat_OK
End Function

I need to pass the source SSN to the stored procedure so it can return the encrypted SSN.

bryan42
Starting Member

28 Posts

Posted - 2007-07-19 : 09:44:07

I gave up on this using VB and accomplished the task with two functions and a stored procedure.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources