Post reply

SSiS package moving data

  • July 8, 2011 at 5:12 am

    #142746

    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.

  • July 8, 2011 at 5:29 am

    #1350257

    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 😉

  • July 8, 2011 at 5:29 am

    #1350258

    In the editor for the OLE DB Source, choose SQL command for your access mode, and simply type in the query that will filter out the rows you don't want.

    John

  • July 8, 2011 at 5:37 am

    #1350264

    Thank you both for your answers, I wasn't thinking outside of the box.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply