SSSIS包数据加载：记录分析的变化 [英] SSSIS package data load: records changes for analytics

问题描述

我有一个POS平面文件，其中包含前一天的所有交易以及过去14天的所有更改。我必须创建一个包来加载到数据库中



我的问题是将它加载到数据库中的最简单方法是什么？



目标：记录用于分析的所有更新和插入。



表中没有主键，我们不应该创建任何新列。



非常感谢您的支持

I have a POS flat file which has all the transactions of the previous day and all the changes for the last 14 days. I have to create a package to load it into the DB

My question is what is the bast way to load it into the database?

GOAL: record all the updates and inserts to be used for analytics.

No primary key in the table and we are not supposed to create any new columns.

Thanks a lot for your support

推荐答案

您将需要数据流任务。



在这里你需要一个flatfile源，然后是数据查找。配置查找以重定向未找到的行和找到的行。使用SQL目标和多播插入到数据库中的数据库到审计/分析表。



或



创建一个flatfile源，读取数据并将数据库插入到临时表中。然后使用SQLCommand任务。将此任务设置为使用具有业务逻辑的存储过程来分析插入和更新。



http://oakdome.com/programming/SSIS_Lookup.php [ ^ ]

You are going to need a dataflow task.

Inside this you are going to need a flatfile source, then a data lookup. configure the lookup to re-direct not found rows and found rows. Insert into the database using SQL destination and multicast that to your audit / analytics table.

OR

create a flatfile source, read the data and insert into your database into a staging table. Then using the SQLCommand task. Set this task to use a stored procedure that has your business logic for analysing the inserts and updates.

http://oakdome.com/programming/SSIS_Lookup.php[^]

这篇关于SSSIS包数据加载：记录分析的变化的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！