SSIS Query from Server A to Server B with Function

[03Explorer]

Server A has SQL server 2000
Server B has SQL Server 2008

I have a query I have that works for Gathering data from Server A. What I want to happen is populate that output data into Server B, but with one change. Instead of direct output from A into B, I want to run a function on server B to change one field and store the new value (after function).

How and where can I find to change the SSIS package from directly importing Server A data into Server B, but use SQL code instead that incorporates the function?

Thanks

 

[ousoonerjoe]

Would a trigger on Server B as the data is "inbound" be better suited for your needs?

--------------------------------------------------
Stubbornness is a virtue -- if you are right. --Chuck Noll
--------------------------------------------------

 

[03Explorer]

I am not versed in the topic or how to work with inbound trigger on Server B... I will Google that topic. Thanks