Post reply

Package setup

  • May 30, 2012 at 12:58 pm

    #269646

    I am new in SSIS and wants to make a package that pulls the data from sql audit file and appends that data in a sql server table. So the source and destination are the same.

    Please suggest how to perform this.

    Thanks

  • May 31, 2012 at 2:06 am

    #1495036

    Take a look at this:

    http://www.sqlservercentral.com/stairway/72494/

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • May 31, 2012 at 9:49 pm

    #1495633

    If the source and destination are the same then a stored procedure should suffice, unless you want to run some of the data through one of the SSIS transformation. At any rate I am not sure if you can read an Audit file from SSIS. sys.fn_get_audit_file is how you pull audit file data into SQL Server.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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