Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mshsilver
Posting Yak Master
112 Posts |
 Posted - 2011-07-08 : 05:42:28
|
| Hi,I have created an SSIS with an OLE DB source and OLE DB destination and successfully got this moving data from one table to another.My issue is I do not want all the data from the source table entered in the data destination. I really need a simple select query added to choose what goes from the source to the destination. Is there something i can add to this or am i doing it the wrong way?Thanks for looking. |
|
|
mshsilver
Posting Yak Master
112 Posts |
Posted - 2011-07-08 : 07:42:16
|
| Here are a few options to my question.One way to accomplish this is to change the data access mode of the oledb source component from Table or View to SQL and write the statement in...alternatively you could create a view that specifies the where clause and use this as your source...there may be other ways but these should work for you |
 |
|
|
|
|
|
Moving data from one table to another