dts programming

[rsx]

Hello,

I have a dts package on Server 1 importing data from Server 2. Values in a table from Server 1 are needed to filter the extraction on Server 2.

Is there a way to do this?

Thanks for any help.

 

[ClaireHCM]

simply link two server, in the Transform Data Task Properties(Source tab), type the select statement query to filter out the data, rest of the steps remains the same

 

[rsx]

hi thanks for responding. when you create the data task it wants you to select the source and destination. how do i link the two servers in the source tab?

 

[rsx]

any other suggestions out there??