Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ActiveX Transformation - for each column

Status
Not open for further replies.
dky1e

dky1e

Programmer
May 4, 2002
293
US
I need to map the following:
Code: 
A     B     C     D
----- ----- ----- -----
a1    b1    c1    d1
a2    b2    c2    d2

to....
Code: 
ColName ColData
------- -----
A       a1
A       a2
B       b1
B       b2
etc....

The source is an xls file and I would like to have an ActiveX transformation that will do...

for each column in source
DTSDestination["ColName"] = column name of the source
DTSDestination["ColData"] = DTSSource[ column name of source ]

I will appreciate any ideas....
 
Status
Not open for further replies.

Similar threads

rss0213
  • Locked
  • Question
data transformation of BIN data?
Replies
0
Views
53
rss0213
rss0213
mxo
  • Locked
  • Question
how to insert a line break in a datagrip column
Replies
1
Views
140
markros
markros
m4pv
  • Locked
  • Question
ActiveX Transformation Script, check the whole record
Replies
1
Views
47
AlexCuse
AlexCuse
RonMck
  • Locked
  • Question
Received Error "Cannot Find Column -1" when exporting
Replies
1
Views
76
RonMck
RonMck
jrennatc3
  • Locked
  • Question
DTS ActiveX code window missing
Replies
0
Views
34
jrennatc3
jrennatc3

Part and Inventory Search

Sponsor

Back
Top