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?