Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to load image into other destination? Expand / Collapse
Author
Message
Posted Thursday, January 30, 2014 12:15 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 7, 2014 4:32 AM
Points: 19, Visits: 50
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
Post #1536183
Posted Thursday, January 30, 2014 3:04 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
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?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1536224
Posted Thursday, January 30, 2014 3:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 7, 2014 4:32 AM
Points: 19, Visits: 50
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
Post #1536236
Posted Thursday, January 30, 2014 3:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: 2 days ago @ 12:52 PM
Points: 13,636, Visits: 11,509
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1536239
Posted Thursday, January 30, 2014 5:41 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, March 7, 2014 4:32 AM
Points: 19, Visits: 50
Yeah.., thank you Koen for your support
Post #1536274
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse