can anyone help me with this or atleast give an idea
-
ok this is the situation im developing a programs that needs a users to map their database table to another table but i want it to be visual to minimize the errors that the users can create can somebody give me an idea on how to do this ? here is a screenshot of a similar interface i got from another software.. http://i111.photobucket.com/albums/n159/jeipiyaku/dtmap.jpg can anyone give me an idea on how to this or atleast tell me of a control that i can use to do this thanks a lot codeproject
-
ok this is the situation im developing a programs that needs a users to map their database table to another table but i want it to be visual to minimize the errors that the users can create can somebody give me an idea on how to do this ? here is a screenshot of a similar interface i got from another software.. http://i111.photobucket.com/albums/n159/jeipiyaku/dtmap.jpg can anyone give me an idea on how to this or atleast tell me of a control that i can use to do this thanks a lot codeproject
-
ok this is the situation im developing a programs that needs a users to map their database table to another table but i want it to be visual to minimize the errors that the users can create can somebody give me an idea on how to do this ? here is a screenshot of a similar interface i got from another software.. http://i111.photobucket.com/albums/n159/jeipiyaku/dtmap.jpg can anyone give me an idea on how to this or atleast tell me of a control that i can use to do this thanks a lot codeproject
I want the old DTS field mapping tool, 2 listboxes and draw lines to map the fields. I must say I'm surprised there is not a custom or third party tool for this.
Never underestimate the power of human stupidity RAH
-
I want the old DTS field mapping tool, 2 listboxes and draw lines to map the fields. I must say I'm surprised there is not a custom or third party tool for this.
Never underestimate the power of human stupidity RAH
-
yeah to think that i wasted my time looking for one.. and yeah thats what im using now 2 listbox.. and im thinking of creating a control for this
As Bob said, maintaining data type integrity is going to be a challenge Whenever we work with ETL we only use VARCHAR and then build a proc to do the transforms only AFTER the data has been loaded into a staging table. One of the reasons I have Biz Talk and SSIS is they try to do the transforms during the load process. I find this hugely complicates the load process. BTW we do not attempt to supply a "flexible" or generic solution to the users, each type of load requires a specific stored proc to do the transforms. Some of the rules are so complex, based on esoteric data that they cannot be supported by an ETL tool. We actually paid from a POC for a Biz Talk organsation, we got back a custom process in C#. Turned out a proc in SQL was orders of magnitude faster!
Never underestimate the power of human stupidity RAH
