locked
USEING SSIS PACKAGE TO IMPORT DATA FROM XML FILE RRS feed

  • Question

  • HI,

    I want to import values of current_time, name, and age from the XML file below. Then I will export those values into sql.

    by using "xml source" I can recieve values from name and age, but not from current_time.

    my question is, how to get the value for current_time(Thu May 19 12:19:29 PDT 2009)?

      <?xml version="1.0" ?>

    - < -queue_currentDate current_time="Thu May 19 12:19:29 PDT 2009">

      <     queue_cnt>1</queue_cnt>

      <     queue name="smith" age="50" />

      </queue_currentDate>

     

    • Moved by Max Wang_1983 Wednesday, April 20, 2011 6:31 AM Forum consolidation (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
    Thursday, June 10, 2010 5:13 PM

Answers


  • This was moved out of the Profile forum.

    I can move it into a specific XML or SQL forum if you'd like.

    This is regarding your code:

    <?xml version="1.0" ?> 
    
    - < -queue_currentDate current_time="Thu May 19 12:19:29 PDT 2009">
    
      <     queue_cnt>1</queue_cnt> 
    
      <     queue name="smith" age="50" /> 
    
      </queue_currentDate>
    
    
    

    Thanks! 


    Ed Price a.k.a User Ed, Microsoft Experience Program Manager (Blog, Twitter, Wiki)
    Saturday, December 24, 2011 7:23 AM