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-16 : 05:15:52
|
| Hi ,I want to do Logging in to Sql Server Database using SSIS Integration Services.I have a simple application of Importing Excel file data into Sql Database... Now during this process whatever steps occur I want to have detail information and log the same into the sql database tables...I have managed to Log the details into text file using the SSIS->Logging menu, over there we have the option of selection the destination as SQL Database but I dint understood from where I can Map to which Sql table the Logging should be done.Waiting for replyIts Urgent...Thanks |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-17 : 03:47:59
|
| It will be logged into a table called sysdtslog90 in the database you specified in the connection.Have a look at this:http://support.microsoft.com/kb/906563 |
 |
|
|
amit.shinde
Starting Member
9 Posts |
Posted - 2009-08-18 : 09:01:13
|
| Thanks for the reply, that really worked for me |
|
|
|
|
|
|
Logging into Sql Server Database using SSIS Sql 20