July 24, 2012 at 9:35 pm
Good evening,
I'm looking for suggestions in setting up a good auditing and logging system for SSIS.
The goal is to have a good respository of information that will create batch id numbers each time a package runs.
As of right now I have data being collected in one table using SSIS package variabes.
1). UserName
2). StartTime
3). EndTime
4). Machine
If one iteration of the package loads 35 files for example I would like it to have say batch number 1,2,3 for subsequent loads.
July 24, 2012 at 9:55 pm
You can Configuring SSIS Logging and keep these information in sysssislog table. Then query this table when you run report.
sysssislog could show following information:id , event , computer , operator , source , sourceid,executionid , starttime , endtime , message
Adding and Configuring Logging:http://msdn.microsoft.com/en-us/library/ms167456(v=sql.105).aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply