OLE DB Source Component to OLED Destination

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

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?

Posted 25-Jul-14 19:28pm

Patrick.MB

Add a Solution

Comments

PIEBALDconsult 26-Jul-14 1:57am

"I configured the source editor to my DB and selected the table I had just created"

It sounds like you are copying from an empty table.
Unfortunately SSIS and BIDS don't really lend themselves to this kind of forum, so I'm not sure how much we'll be able to help.

Patrick.MB 26-Jul-14 2:06am

I was. I had Execute SQL Task in the control flow with a SQL Statement to delete table. I disabled the SQL Task, inserted values into table and ran it again and it worked. Thanks.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)