Post reply

Logging into Sql Server Database using SSIS Sql 2005

  • August 16, 2009 at 3:12 am

    #132659

    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 reply

    Its Urgent...

    Thanks

  • August 16, 2009 at 7:56 am

    #1039948

    Check the links below the first shows the defined SSIS Log providers and the second link shows how to implement custom log provider using Adventureworks database. If you don't have that installed make sure you download and install Adventureworks so you can test the solution before creating your own copy of it using your database.

    http://msdn.microsoft.com/en-us/library/ms140246(SQL.90).aspx

    http://www.mssqltips.com/tip.asp?tip=1417

    Kind regards,
    Gift Peddie

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

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