October 7, 2009 at 3:33 pm
i am new to SSIS but has good design expereince.
the current requirement needs me to a design a process for audit table.
step 1: Basically we load flat files into stage tables and for every file load we want to insert a row into audit table and generate a audit_key with starttimestamp and filename informatin.
step2:while loading flat file into DB table, we also load the above generated audit_key for every row.
step3:After the load is sucessful you need to update the record in the aduit table with job status to "success"..
what is the best approach to do this in SSIS 2008.?
In this process, the step1 and step3 are same for every file load, so can we create the process and reuse for every file? if so how to do that?
Can we have a separate package for step1 and step3 and call those packages in every load package i.e step2?
also in step 2, you do lookup on audit table to get the audit key, how can we create that lookup as reusable lookup ? any thoguths?
October 7, 2009 at 4:20 pm
Duplicate post.
Please continue discussion here .
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply