Best Approach for Files Processed

  • We have an existing ETL process that extracts .zip files into a staging database. In our existing process, we use a special table to capture the names of the files that were extracted. We use a couple of Execute SQL Tasks to populate that table. Now that we are using SSIS 2012 with the Project Deployment model, is there a better way to do this? By the way, I put a script of our Files Processed table below so you can see what we did.

    CREATE TABLE [dbo].[tbl_FilesProcessed](

    [FilesProcessedID] [int] IDENTITY(1,1) NOT NULL,

    [ZipFileName] [varchar](100) NOT NULL,

    [ProcessStartTime] [smalldatetime] NULL,

    [ProcessStopTime] [smalldatetime] NULL,

    [IsProcessed] [bit] NOT NULL,

    CONSTRAINT [PK_tbl_FilesProcessed] PRIMARY KEY CLUSTERED

    (

    [FilesProcessedID] ASC

    )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

    ) ON [PRIMARY]

    GO

  • Your current approach will work fine in SSIS 2012 regardless of the deployment model.

    Regards

    Lempster

  • Good, but does the Project Deployment Model have something built in that might work as well or better?

  • imani_technology (6/26/2014)


    Good, but does the Project Deployment Model have something built in that might work as well or better?

    Not that I am aware of.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply