OLE DB源组件到OLED目标 [英] OLE DB Source Component to OLED Destination

问题描述

我是SSMS和BIDS的新手，我正在尝试进行简单的提取和加载。我在SQL中创建了一个包含数据的表，我正在使用BIDS OLE DB源组件（没有数据转换转换）并使用OLE DB Destination组件。我将源编辑器配置到我的数据库并选择我刚创建的表并单击列并选择列。在OLE DB目标编辑器中，我选择了相同的连接管理器并单击new for table，映射列然后执行包并运行它。问题是，当我在SQL中转到新表时没有数据。请问，我做错了什么？

I'm new to SSMS and BIDS and I'm trying to do a simple extract and load. I created a table in SQL with data and I'm using BIDS OLE DB source Component (with no data conversion transform) and using OLE DB Destination component. I configured the source editor to my DB and selected the table I had just created and clicked on columns and selected the columns. In the OLE DB Destination editor, I selected the same connection manager and clicked on new for table, mapped the columns and then executed the package and it ran. Problem is, no data when I go to the new table in SQL. Please, what am I doing wrong?

推荐答案

这篇关于OLE DB源组件到OLED目标的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！