Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Best Approach for Files Processed Expand / Collapse
Author
Message
Posted Wednesday, June 25, 2014 12:21 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:59 PM
Points: 213, Visits: 572
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
Post #1586044
Posted Thursday, June 26, 2014 2:57 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:58 AM
Points: 2,036, Visits: 1,377
Your current approach will work fine in SSIS 2012 regardless of the deployment model.

Regards
Lempster
Post #1586299
Posted Thursday, June 26, 2014 10:34 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 2, 2014 3:59 PM
Points: 213, Visits: 572
Good, but does the Project Deployment Model have something built in that might work as well or better?
Post #1586562
Posted Friday, June 27, 2014 2:06 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 6:58 AM
Points: 2,036, Visits: 1,377
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.
Post #1586737
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse