import xml data file from the secured website(need id,password to log in)using SSIS

• gopal mehta

  SSC Rookie

  Points: 29

  More actions

  September 24, 2007 at 1:30 pm

  #125854

  Hi

  I need to Import xml data from secured site  with http conenction,,,those files are in zip format on that website.Any idea how to do it with SSIS??

  I would really appreciate if anyone can help me with this

  Thank you

• Ed Zann

  SSCrazy Eights

  Points: 8694

  More actions

  September 24, 2007 at 7:20 pm

  #735836

  I have not done this - but here are my thoughts.

  1 - You need to retrieve the zip file from the secure site.  I think you probably need a Script Task and some VB.Net code to get this done.

  2 - You need to unzip the file.  Probably another Script task and VB.Net code.

  3 - Once the file saved in an XML format you can probably use the XML Data Flow transforms to work with it.

• Crispin Proctor

  SSCoach

  Points: 18161

  More actions

  September 25, 2007 at 1:46 am

  #735911

  The XML source allows for HTTP requests. Get the XML directly from the source.

  Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

• gopal mehta

  SSC Rookie

  Points: 29

  More actions

  September 25, 2007 at 6:33 am

  #735975

  Thanks for the reply guys

  But I am qt new to SSIS so can you give some directions that how to do it with XML TASK?

  all the files are in the zip format....can you suggest any solution for that??

  Thanks!