How do you set up a job to download a zip file directly from a URL onto a DSP server?

Answered

DSP User

• May 07, 2018 10:14

Has anyone ever set up a job to download a zip file directly from a URL onto a DSP server (we are not be able to use Dell Boomi and Universal connect for this circumstance). Here's a link we used: http://www.hc-sc.gc.ca/dhp-mps/alt_formats/zip/prodpharma/databasdon/allfiles.zip Thanks!

1

• Best answer

  

  DSP Expert

  • May 07, 2018 23:28

  PCardoso: Great question Kurt, but this data is publicly available (https://www.canada.ca/en/health-canada/services/drugs-health-products/drug-products/drug-product-database/what-data-extract-drug-product-database.html) and provides as an available dataset for public use. After trolling the interwebs, this link below  seems to be the most comprehensive and likely to work by leveraging SSIS. Although, I haven't tried it myself. http://microsoft-ssis.blogspot.ca/2011/05/download-source-file-from-website-with.html

  0
• 

  DSP Expert

  • May 07, 2018 10:21

  KVandergriend: My first concern is that the link provided appears to be public. How is this client data being secured?

  0
• 

  DSP User

  • May 07, 2018 10:57

  The link is a Government of Canada website that contains the complete Drug Product information from Health Canada.

  0

Please sign in to leave a comment.