SSIS 2008-将xml文件内容导入sql server

用于存储数据的表如下所示:

create table Import_Files
(
    SequenceId              int             IDENTITY(1,1) NOT NULL,
    FileName                varchar(200)    NOT NULL,
    FileXml                 xml             NOT NULL,
    Created                 datetime        DEFAULT(GETDATE()) NOT NULL,
    Processed               bit             DEFAULT(0) NOT NULL
)

我的存储过程:

CREATE PROCEDURE [dbo].[AddFile] 
    @FileName   varchar(200),
    @FileXml    xml
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    --Add new record
    INSERT INTO Import_Files
    ([FileName], FileXml)
    VALUES
    (@FileName, @FileXml)

END