SQl Server Integration Services

Question

Post reply

SQl Server Integration Services

vjparmar2007

Valued Member

Points: 71
More actions
December 17, 2009 at 10:03 am

#137680

How to use our Log Table instead of System Generated?
and Change Variable According to us Table for Example TotalRow and PackageExecutionTime etc.

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

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

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 1

[font="Comic Sans MS"]

Check this out:

http://consultingblogs.emc.com/jamiethomson/archive/2005/06/11/SSIS_3A00_-Custom-Logging-Using-Event-Handlers.aspx

or

http://www.sqlmag.com/Article/ArticleID/100005/sql_server_100005.html

or

http://download.microsoft.com/download/4/1/f/41f09116-19b3-40fe-9d54-d1e9b7af9e82/ProjectREAL_ETLDP.doc

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

vjparmar2007 Valued Member Points: 71 More actions · Answer 2

I Tried it all your link but me not getting my solution of what i want.

me want one table called LOG of not system table instead of user define table and me want to insert error as well as packagename,totalrow,timetaken,error,username,status of package success or failure so help me for that..!