SQL Server Performance

import xml files

Discussion in 'SQL Server 2005 Integration Services' started by fmardani, Jul 4, 2007.

  1. fmardani New Member

    I have created a stored procedure to handle xml data.
    One of the inputs to this procedure is xmldata which is basically the contents of the xml in a file.
    Now I would like to create a SSIS package that takes the xml files from the network and uses this SP.
    Should I have a file system task inside a for loop container?
    How do I get started on this please?
    Thanks
  2. satya Moderator

    See under updated books online for SQL 2005 - ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/5d5be54c-2b7e-4957-9193-c5ea5c5d6d15.htm for XML Source topoic.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. dineshasanka Moderator

Share This Page