June 25, 2014 at 12:21 pm
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
June 26, 2014 at 2:57 am
Your current approach will work fine in SSIS 2012 regardless of the deployment model.
Regards
Lempster
June 26, 2014 at 10:34 am
Good, but does the Project Deployment Model have something built in that might work as well or better?
June 27, 2014 at 2:06 am
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