Corrado |
Newbie |
|
Canada |
Database Developer |
|
Male |
|
Wednesday, February 10, 2021 |
Thursday, May 4, 2023 3:10:03 PM |
8 [0.04% of all post / 0.01 posts per day] |
|
Hello, I have MS SQL server with databases DB1, DB2, DB3, DB4. In my mapping I have source and destination database. I need to be able to switch both source and destination databases, as needed. For example, first run mapping for source DB1 and destination DB2. Then I need to run same mapping for source DB1 and destination DB3. Then I need to run same mapping for source DB2 and destination DB1.
I know I can use Global Resource for keeping all these connections, rather than edit or create new mapping for each combination. But seems there is only 1 Active Configuration that can be used for a mapping at a time? I have assigned Global Resource to both source and destination databases. But when I change Active Configuration, it changes to the same DB for both databases.. Is there a way to store DBs in Global Resource, but choose them independently for source and destination? Thanks
|
Stored procedure processes child records (converts some text values). After executing mapping I see that the values were not processed. Installing MapForce server could be an option, but this is another product which we still have to install and pay for. I was just hoping that it can be resolved without server. I have contacted support, now waiting for response. Thanks again.
|
Thank you for your suggestion! I have tried this, but apparently it did not work, as procedure name was not even a part of Output script.. Also, sorry, I had to mention that there are child tables on both sides of source and target. So procedure must be executed after complete script is finished, after all parent/child relationships were processed. Now I doubt if it is possible at all with MapForce..
|
Thank you for your suggestion! I have tried this, but apparently it did not work, as procedure name was not even a part of Output script.. Also, sorry, I had to mention that there are child tables on both sides of source and target. So procedure must be executed after complete script is finished, after all parent/child relationships were processed. Now I doubt if it is possible at all with MapForce..
|
Hello, I have mapping that inserts record into MS SQL database. I need to execute SQL script or stored procedure for this newly created record. How do I do this? I have tried this on the image below, but it does not work..
|
Thank you!
|
Hello, I have mapping, implemented to import XML files into MS Access database. Now I need to do the same import into MS SQL database. Table names and column names in both databases are identical. Is it possible to just change destination database, and re-use existing mapping? I have tried, but "old" Access tables keep showing with red question marks.. Thank you
|
Hello, I need to use Join Component with Left Join to one of the tables, in database to xml mapping. When record in the joined table exists, it generates XML output fine, like this: <Carrier> <ID>122294341RM0001</ID> </Carrier> But when record in the joined table does not exists, it generates XML output, like this: </Carrier>
I have tried to use substitute-null function, so if ID is null then it will be replaced with empty string "" then it looks like this: <Carrier> <ID></ID> </Carrier>
But how can I achieve that output node Carrier will not be created at all? Thank you
|
|