更新时间:2023-01-21 22:52:43
您可以创建宽表" ,但是它有其自身的局限性和局限性.您可能将无法使用该向导.如果您希望SSIS包定期执行此操作(这就是该向导的内容),则必须退出Visual Studio并构建一个.
You can create a "wide table" but that comes with its own limitations and restrictions. You probably won't be able to use the wizard for this; if you want an SSIS package to do it regularly (which is what the wizard is under the covers), you'll have to pull out Visual Studio and build one.
我建议您将数据转换为具有更多表和更少表的更规范化的形式.或者,考虑您的数据根本无法很好地适合此模型的可能性,而是使用诸如Hadoop或其他NoSQL数据库之类的大数据"平台.
I would instead advise that you transform the data into a more normalized form with more tables and fewer columns per table. Or, consider the possibility that your data doesn't fit well into this model at all and instead use a "big data" platform like Hadoop or other NoSQL database.