Hello
Kindly i need support in this issue, i create task flow import from flat file and store in database but i need to save all result for task into specific table
Like Record count transferred
Destination table name
Time ..........etc
thanks
Sounds like you are looking for auditing information. Watch the Kimball Webcast on the main page of this forum. Plenty of examples in there.
In summary, you'll populate variables in your data flow, and then after the data flow completes, you'll use an Execute SQL task in the control flow to perform an insert statement into your "specific table" using those variables previously populated.|||where in the main page ?|||
Hosam Abd EL-Wahab wrote:
where in the main page ?
The Ralph Kimball Group Webcast
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=534505&SiteID=1
No comments:
Post a Comment