February 1, 2006 at 10:22 am
I'm used to working with DTS packages in EM. We have converted to SQL Server 2005 and I need to convert some DTS packages to DTSX. Inside of my DTS package I have an activeX script(VB) using DTSSource("name") and DTSDestination("name"). This was how I did the data transformation. I know when inside a DTSX that Row.name would replace DTSSource("name"), but what object replaces DTSDestination? Any help would be greatly appreciated. Thanks in advanceWayne
February 2, 2006 at 7:01 am
There are two approaches you can take.
1) If you are not doing transformations on the data in question, use a data flow task with a straight copy of rows using a Source Connector and a Destination Connector. Do you mapping in the properties of the Destination Connector.
2) If you are doing transfermations or applying business rules on a column, you can use the Source Connector -> Script Component Task -> Destination Connector logic. Within the Script Component Taks, you should be able to apply your business rules. And again, you would map your columns in the DestinatioN Connector properties.
Cliff
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply