tgatif
asked on
**WHAT IS DTSSource and DTSDestination in DTS**
I like to know about DTS application. I like to know about DTSSource and DTSDestination. How can I implement them in an activeX control.
Please give me a simple example.
Please give me a simple example.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Also in ActiveX Transformation Window. I am not seeing Nodes "Source Columns" and "Destination Columns" under Package Object Browser. I can see Noes "Tasks Constant", "Step Constant" and "Global Variables". How can I setup "Source Columns" and "Destination Columns"
In the TransformData Task on source tab you can select a table as a Source or write/build a query as a source
On the Destination tab you can populate the Destination columns from the datasource it self
Then in the transformations tabs map the different souce with the destination as you like
On the Destination tab you can populate the Destination columns from the datasource it self
Then in the transformations tabs map the different souce with the destination as you like
Sorry I did not read your previous comment
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
In the Precedence Tab, **New** button is disabled.
ASKER
In the DTS, I have only task---ActiveX Script Task
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You need a source and a destination first to transform the data, Data Transformation Service from a source to Destination, Server - Server, Server - File...............
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
The website does not help me in my question. If you can answer, I really appreciate it.
Thanks