Post reply

how to do a Where statement in Data Flow

  • October 1, 2008 at 12:09 pm

    #191713

    Hi,

    how i can do a Where statement in the Data Flow?

    i first set the OLE DB source to connect to the table that i want,and then what transformation i need to use to make the Where.

    THX

  • October 1, 2008 at 12:22 pm

    #879676

    You can edit your the SQL that you use to access your data source to include a where clause.

    Or you can use a conditional split data flow transformation to filter the data in a similar fashion to the where clause.

  • October 1, 2008 at 12:55 pm

    #879695

    THX.

    i didn't see in the OLE DB that i have the sql command instead i use the table connection.

  • October 1, 2008 at 2:16 pm

    #879729

    Hi instead of selecting the table or view in the DATA ACCESS MODE of OLE DB Source Editor u can use SQL COMMAND from the drop down and give the query with where clause

    select * from tableA where

    hope this will help u out

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

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