Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amit.shinde
Starting Member
9 Posts |
 Posted - 2009-08-18 : 09:06:51
|
| Hi,When I do the Logging from SSIS->Logging to SqlServer. The logging is done in SysdtsLog90.Now When I run two packages both of them log into the same table and I dont have anything unique in the rows so as to identify which logging belongs to which package.So I want to log Package Name into SysdtsLog90.Please tell me how will I be able to create an extra column into SysdtsLog90 for inserting PackageName into SysdtsLog90Orelse Please suggest me any field by which I will be able to identify the Logging for particular Package.Waiting for reply |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-18 : 09:58:15
|
| The [source] column in sysdtslog90 should have the package/executable name. |
 |
|
|
amit.shinde
Starting Member
9 Posts |
Posted - 2009-08-18 : 10:11:01
|
| The [source] column in sysdtslog90 Is the name of the ControlFlow Item... |
|
|
|
varunragul
Starting Member
10 Posts |
Posted - 2009-08-18 : 10:18:59
|
| First u have to understand the Strcuture od SYSDTSLOG90ExecutionID in Sysdtslog90 is unique for a package execution,use the below query to identify the package name Select executionID,Source from Sysdtslog90 where event = 'packageStart'group by executionID,Source u can also "PackageEnd" as event to get packgename |
|
|
|
amit.shinde
Starting Member
9 Posts |
Posted - 2009-08-18 : 10:43:24
|
| So that would be unique for eack package I execute ? |
|
|
|
amit.shinde
Starting Member
9 Posts |
Posted - 2009-08-18 : 10:57:15
|
| Thanks for the reply... |
|
|
|
|
|
|
Creating new column in SysdtsLog90