How to load image into other destination?

  • Hi Experts,

    Can anyone tell me how to load images from the database into my desktop.

    I have imported image path into database using import column and using export column to export back the image to desktop but in different location.

    When i use export column, it is showing the same path from where am importing.

    for example: if am importing image into database from c:\desktop\import folder

    again when am using export column it is again loading the image into same path but i want to load into another path c:\desktop\export folder.

    How can i achieve this.. I think exporting and importing into the same folder is not correct.

    We'll import from one folder only to export it to other folder. So kindly suggest me the solution.

    BEst Regards,

    VijayVanamala

  • Can't you specify another path in the source query? Or use a variable in a derived column to add the destination path to the flow?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Hi Koen,

    Thanks for your suggestion, I have added another row in source query with other destination address and could able to export the file to multiple destinations ata atime.

    Also, i have tried with variable. Declatred a variable with some address and then executed successfully.

    What i observed in export column is., we can only select one path i.e., either the path given in query or the path in variable.

    Am i correct??. How to change the topic to solved here?. Is there any option to do so?

    Thanks for your help. 🙂

    Best Regards,

    VijayVanamala

  • You can indeed only choose one option.

    If you have multiple destinations for your files, you need to get it in the source query (store it alongside in the table?).

    A variable will be no good here.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Yeah.., thank you Koen for your support 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply